Updating
iPhone Screenshots
Description
Will you start learning SQL in MySQL?
Did you forget the statements many times?
Do you no longer remember the syntax and the result of an statement?
Developed to easily learn SQL Programming for MySQL
. . . . . . . . . . . . . . . . . . . . .
This App acts as a reference for the SQL language
Learn DML & DDL statements with description, syntax, notes and examples
For each statement is presented:
Detailed description of the statement/command purpose
Syntax of the statement with various options
Two examples executed from a real table (Automobile Table)
Provides:
. . . . . . . . . . . . . . . . . . . . .
1. GENERAL
1.1 - Comments
1.2 - Data Types
2. (DML) Data Manipulation Language
2.1 – SELECT
- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Limit, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union (Any & All)
- Subqueries
- Joins (Inner, Right, Left)
- Select Into
2.2 - INSERT
- With Columns names
- Without Column names
- Rules
- Insert Into ... Select
2.3 - DELETE
- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity
2.4 - UPDATE
- Update All Rows
- Update ... Where
- Rules
3. (DDL) DATA DEFINITION LANGUAGE
3.1 - CREATE
- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN)
3.2 - ALTER
- Alter Columns
- Add Constraints
- Drop Constrains
3.3 - DROP
- Drop Table
- Drop Database
- Drop Index
3.4 - TUNCATE
- Delete Versus Truncate
What's New in Version 2.1
Supports devices with dark mode enabled
Seller
Name
Paulo Narra
Information
Developer
Categories
Version
2.1
Size
6.2 MB
Game Center
No
VPP Device Licensing
Yes
Rating
Rated: 4+
Compatibility
iOS 13.0 or later
Devices
iPhone 5s, iPhone 6, iPhone 6 Plus, iPhone 6s, iPhone 6s Plus, iPhone SE, iPhone 7, iPhone 7 Plus, iPhone 8, iPhone 8 Plus, iPhone X, iPhone XR, iPhone XS, iPhone XS Max, iPhone 11, iPhone 11 Pro, iPhone 11 Pro Max, iPhone SE (2nd generation), iPhone 12, iPhone 12 Pro, iPhone 12 Pro Max, iPhone 12 mini, iPhone 13, iPhone 13 Pro, iPhone 13 Pro Max, iPhone 13 mini, iPad (5th Generation) Wi-Fi, iPad (5th Generation) Wi-Fi + Cellular, iPad (6th generation) Wi-Fi, iPad (6th generation) Wi-Fi + Cellular, iPad Pro, iPad Pro (Cellular), iPad Pro (9.7-inch), iPad Pro (9.7-inch) (Cellular), iPad Pro 12.9-inch (2nd generation), iPad Pro 12.9-inch (2nd generation) Wi-Fi + Cellular, iPad Pro (10.5-inch), iPad Pro (10.5-inch) Wi-Fi + Cellular, iPad Pro (11-inch), iPad Pro (11-inch) Wi-Fi + Cellular, iPad Pro 12.9-inch (3rd generation), iPad Pro 12.9-inch (3rd generation) Wi-Fi + Cellular, iPad Air, iPad Air (Cellular), iPad Air 2, iPad Air 2 (Cellular), iPad Air (3rd generation), iPad Air (3rd generation) Wi-Fi + Cellular, iPad mini Retina, iPad mini Retina (Cellular), iPad mini 3, iPad mini 3 (Cellular), iPad mini 4, iPad mini 4 (Cellular), iPad mini (5th Generation), iPad mini (5th Generation) Wi-Fi + Cellular, iPad (7th generation) Wi-Fi + Cellular, iPad Pro 11-inch (2nd generation), iPad Pro 11-inch (2nd generation) Wi-Fi + Cellular, iPad Pro 12.9-inch (4th generation), iPad Pro 12.9-inch (4th generation) Wi-Fi + Cellular, iPad Air (4th Generation) (Wi-Fi), iPad Air (4th Generation) (Wi-Fi + Cellular), iPad (8th generation) Wi-Fi, iPad (8th generation) Wi-Fi + Cellular, iPad Pro 11-inch (3rd generation), iPad Pro 11-inch (3rd generation) Wi-Fi + Cellular, iPad Pro 12.9-inch (5th Generation), iPad Pro 12.9-inch (5th Generation) Wi-Fi + Cellular, iPad (9th Generation), iPad (9th Generation) Wi-Fi + Cellular, iPad mini (6th Generation), iPad mini (6th Generation) Wi-Fi + Cellular, iPod touch (6th Generation), iPod touch (7th generation), Mac Desktop
Languages
English, Chinese, Portuguese, Spanish
App Store: Customer Ratings
Ratings & Reviews
0.0 of 5 (No rating)
App Store: Customer Reviews
No Entry