Learn SQL for MySQL
SQL Language for MySQL
#1 Keyword Rankings
Today
Top 10 Rankings
Today
Top 30 Rankings
Today
Top 100 Rankings
Today
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
0 out of 5
0 ratings in Kazakhstan
Ratings History
Reviews
App doesn't have any reviews yet
Store Rankings
Ranking History
App Ranking History not available yet
Category Rankings
|
Chart
|
Category
|
Rank
|
|---|---|---|
|
Top Paid
|
|
14
|
|
Top Paid
|
|
21
|
|
Top Paid
|
|
33
|
|
Top Paid
|
|
37
|
|
Top Paid
|
|
40
|
Keywords
Users may also like
| Name | Reviews | Recent release | |
|---|---|---|---|
mitmproxy helper by txthinking
TCP/IP layer, NOT system proxy
|
0
|
1 year ago | |
Wireshark Helper - Decrypt TLS
All TCP/UDP to Wireshark
|
0
|
1 year ago | |
php - programming language
Good helper for PHP Learn
|
0
|
1 year ago | |
UDevice - Dev Assistant
Geek/Developer Kit
|
0
|
3 weeks ago | |
Python Recipes Pro
|
0
|
1 week ago | |
SSH Term Pro
Quickly manage SSH server
|
0
|
1 month ago | |
Zeitgeist
Track your Vercel deployments
|
0
|
3 months ago | |
Recipes for Swift Pro
|
0
|
3 weeks ago | |
SQL & MySQL - Learn Databases
Learn SQL & MySQL Databases
|
0
|
2 months ago | |
HTTP Utility Bot Request
Custom Developer Tools
|
0
|
1 year ago |
Show More
Revenue and Downloads
Gain valuable insights into Learn SQL for MySQL performance with our analytics. Sign up now
to
access downloads, revenue, and more.
App Info
- Category
- Developer Tools
- Publisher
- Paulo Narra
- Languages
- English, Portuguese, Chinese, Spanish
- Recent version
- 2.1 (2 years 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
- 1 month ago