|
|
|
|
| SQL / MySQL Home |
|
|
Select Clause
|
| Alias ( 4 ) | Count ( 14 ) | Distinct ( 5 ) | Exists ( 1 ) | Function In Select ( 1 ) | Group ( 15 ) |
| In ( 7 ) | Like ( 7 ) | Limits ( 8 ) | Select ( 11 ) | Simple Select ( 1 ) | Sort Order ( 18 ) |
| Sub query ( 15 ) | Unique ( 3 ) | Using ( 2 ) |
|
Where Clause
|
| And ( 5 ) | OR ( 4 ) | Where ( 13 ) |
|
Insert Delete Update
|
| Delete ( 6 ) | Insert ( 7 ) | Update ( 8 ) |
|
Flow Control
|
| CASE WHEN Select ( 6 ) | Flow Control Select ( 1 ) | IF ( 1 ) |
|
Data Type
|
| AUTO INCREMENT ( 1 ) | Data Type Convert ( 1 ) | Data Type Summary ( 1 ) | Decimal ( 1 ) | ENUM ( 6 ) | FullText ( 1 ) |
| Integer Type ( 5 ) | Null ( 13 ) | Small Int ( 1 ) | Text Type ( 1 ) | Tiny Int ( 1 ) | Varchar ( 1 ) |
|
Date Time
|
| Date Compare Order ( 6 ) | Date Format ( 5 ) | Date Function ( 9 ) | Date Time Function ( 1 ) | Date Type ( 10 ) | Day ( 2 ) |
| Month ( 6 ) | Time ( 1 ) | Year ( 3 ) |
|
String
|
| Regular Expression ( 19 ) | String Append ( 6 ) | String Case Function ( 1 ) | String Compare ( 1 ) | String Function ( 2 ) | String Length ( 1 ) |
| String Type ( 3 ) | Sub String ( 1 ) |
|
Math
|
| ABS ( 2 ) | ACOS ( 1 ) | ASIN ( 1 ) | ATAN ( 2 ) | Average ( 4 ) | COS ( 1 ) |
| COT ( 1 ) | Degree ( 1 ) | Exp ( 1 ) | Floor Ceiling ( 2 ) | LOG ( 2 ) | Max Min ( 1 ) |
| Max ( 3 ) | Min ( 1 ) | MOD ( 1 ) | PI ( 1 ) | PLUS ( 1 ) | Power ( 1 ) |
| RADIANS ( 1 ) | Random ( 1 ) | Round ( 1 ) | SIN ( 2 ) | Sum ( 8 ) | |
| TAN ( 1 ) | TRUNCATE ( 1 ) |
|
Function
|
| Between ( 3 ) | BIT Count ( 1 ) | Compare Function ( 1 ) | Define Function ( 1 ) | Function In Join ( 2 ) | Function In Select ( 1 ) |
| INSTR ( 1 ) | MySQL Version ( 1 ) | Replace ( 4 ) | Right ( 1 ) | SIGN ( 1 ) |
|
Database
|
| Create Database ( 1 ) | Current Database ( 2 ) |
|
Backup Load
|
| Backup ( 1 ) | Batch ( 1 ) | Dump ( 1 ) | Export ( 3 ) | Load Data Into Table ( 2 ) | Load Text File ( 1 ) |
| Save To Text File ( 2 ) |
|
Command MySQL
|
| Connect MySQL ( 1 ) | Exit MySQL ( 1 ) |
|
User Permission
|
| Add User ( 1 ) | Grant ( 1 ) | Password ( 1 ) | Permission ( 1 ) | SQL Privilege ( 11 ) | User Create ( 2 ) |
|
Table Index
|
| Alter Table ( 8 ) | Backup Table ( 6 ) | Constraint ( 3 ) | Copy Table ( 6 ) | Create Table ( 19 ) | Current Table ( 1 ) |
| Default Value ( 1 ) | Delete Table ( 3 ) | Drop Table ( 1 ) | Index ( 4 ) | Rename Table ( 1 ) | Table Structure ( 1 ) |
| Temporary Table ( 1 ) |
|
Join
|
| Condition JOIN ( 1 ) | Cross Join ( 1 ) | Delete From Join ( 3 ) | Function In Join ( 2 ) | Inner Join ( 1 ) | Join Delete ( 3 ) |
| Join Order ( 1 ) | Join Select ( 1 ) | Join Table ( 2 ) | Join Three Tables ( 2 ) | Join Update ( 2 ) | Left Join ( 4 ) |
| Right Join ( 1 ) | Simple JOIN ( 6 ) |
|
Transaction
|
| RollBack ( 1 ) | TRANSACTION COMMIT ( 1 ) | TRANSACTION ROLLBACK ( 3 ) |
|
Key
|
| Foreign Key ( 1 ) | Primary Key ( 4 ) |