Learn SQL for MySQL3 - App Store
You'll be able to see results in few seconds.
Official App Store Link
We do not host Learn SQL for MySQL on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by Apple and passed their terms and conditions to be listed there. We recommend caution when installing it.
The App Store link for Learn SQL for MySQL is provided to you by soft112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of soft112.com contact us.
Publisher 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
Version History App update to support new IOS 3 07/31/2024 Supports devices with dark mode enabled 2.1 12/12/2021 ** Possibility to implement SQL programming directly in the App **
(no internet connection required)
Bug fixes and performance improvements 2.0 07/16/2021 Minor fixes
App design changes
Introduction of new languages: Portuguese (PT), Portuguese (BR), Spanish and Chinese (Simplified) 1.3 03/07/2021 Minor corrections
Changes to the graphical environment 1.2 02/03/2021 1.0 07/02/2020
