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
Hide..
Show more..
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
Screenshots
User Rating
App is not rated in Pakistan yet.
Ratings History
Learn SQL for MySQL Installs
Last 30 days
Learn SQL for MySQL Revenue
Last 30 daysLearn SQL for MySQL Reviews
Store Rankings
Ranking History
App Ranking History not available yet
Category Rankings
|
Chart
|
Category
|
Rank
|
|---|---|---|
|
Top Paid
|
|
3
|
|
Top Grossing
|
|
15
|
|
Top Paid
|
|
22
|
|
Top Grossing
|
|
30
|
|
Top Paid
|
|
38
|
Keywords
Learn SQL for MySQL Competitors
| Name | Reviews | Recent release | |
|---|---|---|---|
mitmproxy helper by txthinking
TCP/IP layer, NOT system proxy
|
0
|
1 year ago | |
WebDebug - Web debugging tool
Web Inspector & Static Server
|
1
|
3 months ago | |
Wireshark Helper - Decrypt TLS
All TCP/UDP to Wireshark
|
0
|
1 year ago | |
UDevice - Dev Assistant
Hacker/Developer Kit
|
0
|
3 months ago | |
Kotlin Recipes
|
0
|
1 year ago | |
SSH Term Pro
Quickly manage SSH server
|
0
|
1 month ago | |
Zeitgeist
|
0
|
2 weeks ago | |
SMTPTester - Test smtp service
Test SMTP Server.
|
0
|
1 year ago | |
SQL & MySQL - Learn Databases
Learn SQL & MySQL Databases
|
0
|
5 months ago | |
N/A
Master Regular Expressions
|
0
|
6 months ago |
Learn SQL for MySQL Revenue and Downloads
Gain valuable insights into Learn SQL for MySQL performance with our analytics.
Sign up now to access downloads, revenue, and more.
Sign up now to access downloads, revenue, and more.
App Info
- Category
- Developer Tools
- Publisher
- Paulo Narra
- Languages
- English, Portuguese, Chinese, Spanish, Chinese
- Recent version
- 3 (2 months ago )
- Released on
- Jul 2, 2020 (4 years ago )
- Also available in
- United States, Pakistan, Italy, Japan, South Korea, Kuwait, Kazakhstan, Lebanon, Mexico, Malaysia, Nigeria, Netherlands, Norway, New Zealand, Peru, Philippines, India, Poland, Portugal, Romania, Russia, Saudi Arabia, Sweden, Singapore, Thailand, Turkey, Taiwan, Ukraine, Vietnam, South Africa, Denmark, Argentina, Austria, Australia, Azerbaijan, Belgium, Brazil, Belarus, Canada, Switzerland, Chile, China, Colombia, Czechia, Germany, United Arab Emirates, Dominican Republic, Algeria, Ecuador, Egypt, Spain, Finland, France, United Kingdom, Greece, Hong Kong, Hungary, Indonesia, Ireland, Israel
- Last updated
- 4 weeks ago