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 Finland
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
|
|
22
|
|
Top Paid
|
|
35
|
|
Top Paid
|
|
35
|
|
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 | |
WebDebug - Web debugging tool
Web Inspector & Static Server
|
0
|
6 days ago | |
Wireshark Helper - Decrypt TLS
All TCP/UDP to Wireshark
|
0
|
1 year ago | |
UDevice - Dev Assistant
Geek/Developer Kit
|
0
|
2 weeks ago | |
Kotlin Recipes
|
0
|
9 months ago | |
SSH Term Pro
Quickly manage SSH server
|
0
|
1 month ago | |
Zeitgeist
Track your Vercel deployments
|
0
|
2 months ago | |
SMTPTester - Test smtp service
Test SMTP Server.
|
0
|
1 year ago | |
SQL & MySQL - Learn Databases
Learn SQL & MySQL Databases
|
0
|
2 months ago | |
RegexMate - 正则表达式伴侣
|
0
|
3 months 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
- 2 weeks ago