SQL / MySQL examples (example source code) Organized by topic

SQL / MySQL

Procedure Function /

Begin End 1 BIGINT 2

Buildin Functions 6 Call 6

CASE 5 CHAR 1

Condition HANDLER 10 Create Table 3

CSharp 2 DATE 3

DATETIME 1 Default 2

DEFINER 1 Delete 2

Delimiter 1 DETERMINISTIC 1

DOUBLE 1 Drop Table 1

Dynamic Statement 2 FLOAT 2

Function Data Dictionary 3 Function Returning 7

Function 10 IF statement 5

Insert 4 INT 1

Introduction 8 ITERATE 1

Java 2 LEAVE 3

Lock 1 LOOP 6

NUMERIC 2 Operator 2

Output 3 Parameters 15

Perl 2 PHP 2

Predefined Exceptions 3 Procedure Data Dictionary 5

Procedure 14 Python 1

Recursion 1 Repeat until 4

Select Into 3 Set 4

TEXT 2 Transaction 7

Update Table 2 VARCHAR 2

Variable Assignment 3 Variable Declaration 3

Variable Scope 5 VB.net 1

While 4

Trigger /

After Trigger 3 Before Trigger 7

Drop Trigger 1 NEW 4

Trigger Data Dictionary 1

View /

Alter View 2 Check 3

Create View 17 Drop View 1

Explain View 1 Nested View 1

Updatable View 1 View Structure 2

Cursor /

Close 1 Declare 3

Fetch 8 Handler 1

Open 1

Select Clause /

Alias 7 All 8

Any 7 Count 14

Distinct 16 Exists 7

Function In Select 1 Group 45

HAVING 7 In 14

Like 11 Limits 27

Operator 14 ROLLUP 4

Row 6 Select 13

Simple Select 13 Sort Order 69

Sub query 68 Union 31

Unique 3 Using 2

Where Clause /

And 12 OR 6

Where 30

Insert Delete Update /

Delete 14 Insert 24

Update 25

Flow Control /

CASE WHEN Select 6 Flow Control Select 1

IF 2

Data Type /

AUTO_INCREMENT 19 BigInt 1

Bit 1 Blob 3

Boolean 3 Char 13

Data Type Convert 1 Data Type Summary 5

Date 10 DateTime 5

Decimal 9 Double 2

ENUM 30 Float 5

FullText 1 Int 7

Integer Type 9 LongBlob 1

LongText 1 MediumBlob 1

MediumInt 1 MediumText 1

Null 22 Serial 1

Set 6 Small Int 7

Text Type 3 Time 3

TimeStamp 13 Tiny Int 4

TinyBlob 1 TinyText 1

Varchar 7 Year 1

Date Time /

ADDDATE 7 ADDTIME 3

CURDATE 4 CURTIME 2

Date Compare Order 6 Date Format 29

Date Function 11 Date Time Function 1

Date Type 13 DATE 7

DATEDIFF 2 DATETIME 3

DATE_ADD 9 DATE_FORMAT 2

DATE_SUB 6 Day 3

DAYNAME 8 DAYOFMONTH 2

DAYOFWEEK 5 DAYOFYEAR 3

EXTRACT 1 FROM_DAYS 2

FROM_UNIXTIME 3 GET_FORMAT 1

HOUR 2 INTERVAL 14

MINUTE 1 Month 10

MONTHNAME 2 NOW 2

SECOND 2 SEC_TO_TIME 4

SUBDATE 2 Time zone 6

Time 8 TIMEDIFF 2

TIMESTAMP 7 TIMESTAMPADD 1

TIMESTAMPDIFF 1 TIME_FORMAT 3

TIME_TO_SEC 9 TO_DAYS 6

UNIX_TIMESTAMP 5 UTC_TIMESTAMP 1

WEEKDAY 2 Year 38

String /

ASCII 3 Binary 11

CHAR_LENGTH 2 COLLATION 1

CONCAT 12 CONCAT_WS 3

CONVERT 3 Escape 2

INSTR 1 LEFT 4

LENGTH 9 LOCATE 4

LOWER 2 Mid 2

ORD 1 REPEAT 2

REPLACE 2 REVERSE 1

RIGHT 4 Row 3

RPAD 1 SOUNDEX 1

STRCMP 2 String Append 6

String Case Function 1 String Compare 8

String Function 2 String Length 1

String Type 3 Sub String 2

SUBSTRING 10 SUBSTRING_INDEX 3

Trim 3 UPPER 1

Math /

ABS 2 ACOS 1

ASIN 1 ATAN 2

Average 4 CEIL 1

COS 1 COT 3

Degree 1 Exp 1

Floor Ceiling 2 FLOOR 5

GREATEST 1 LEAST 1

LOG 2 LPAD 1

Max Min 1 Max 3

MID 1 Min 1

MOD 5 PI 2

PLUS 1 Power 3

RADIANS 1 Random 1

Round 3 SIN 2

SQRT 2 Sum 8

TAN 1 TRUNCATE 2

Function /

AND 2 Between 7

BIN 2 BINARY 1

BIT Count 1 Bit 13

BIT_AND 1 BIT_OR 1

BIT_XOR 2 CASE 21

CAST 8 COALESCE 3

COERCIBILITY 1 Compare Function 1

CONNECTION_ID 1 CONV 2

COT 1 DECODE 1

Define Function 4 EXTRACT 1

FIELD 1 FOUND_ROWS 2

Function In Join 2 Function In Select 2

IF 6 IFNULL 7

IN 4 INET_ATON 3

INSTR 1 ISNULL 1

LAST_INSERT_ID 6 MD5 4

MySQL Version 1 NULLIF 1

OR 2 RAND 12

Replace 7 Right 1

SHA 1 SIGN 1

XOR 2

Aggregate Functions /

AVG 8 COUNT 31

GROUP_CONCAT 3 MAX 10

MIN 9 STD 1

STDDEV 1 STDDEV_SAMP 1

SUM 11 VARIANCE 1

Geometric /

AREA 3 ASTEXT 3

Bounding Box 1 Distance 2

ENDPOINT 1 ENVELOPE 1

Geometric Functions 2 Geometric Objects 1

Geometric Types 2 GeometryCollection 2

GEOMFROMTEXT 3 Index 2

Length 3 Line 1

MULTIPOINT 1 Point 3

polygon 4 TOUCHES 1

X 1 Y 1

XML /

Descendant 1 Element 8

EXTRACTVALUE 13 Update 1

UPDATEXML 1 XPath 1

Regular Expression /

Begin With 10 Class 1

Contains 10 End With 5

Introduction 23 Like 17

Patterns 10 Percentage wildcard 4

REGEXP 21 Underscore 1

I18N /

CHARSET 21 Collate 22

utf8 5

FullText Search /

Boolean Search 9 Index 6

MATCH 16 Natural Language 3

Operator 3 Word 15

Database /

Create Database 2 Current Database 3

Event /

Alter 1 Create 10

Drop 1 Enable 1

Rename 1 Schedule 6

Backup Load /

Backup 1 Batch 1

Dump 1 Export 3

Load Data Into Table 13 Load Text File 2

Save To Text File 18

Command MySQL /

ANALYZE 1 BACKUP 2

Cancel 1 CHECK 2

CHECKSUM 1 Clear 1

Comment 3 Connect MySQL 1

Database 1 DEALLOCATE 1

DESCRIBE 3 Drop 2

Exit MySQL 1 EXPLAIN 3

Global Variables 10 INFORMATION_SCHEMA 9

LOAD 15 Lock 1

Matadata 8 my.cnf 3

MySQL 43 Mysqladmin 10

mysqldump 26 mysqlhotcopy 1

mysqlimport 5 OPTIMIZE 3

PREPARE 3 RENAME 7

Repair 2 RESTORE 1

Set 1 Show 41

SOURCE 1 Status 1

User Permission /

Add User 5 Drop User 3

Grant 53 Password 33

Permission 3 Privilege 1

Rename User 1 REVOKE 7

SQL Privilege 11 User Create 2

User Table 8 USER 10

Table Index /

Alter Table 44 Backup Table 6

Check 3 Column 77

Constraint 4 Copy Table 17

Create Table 32 Current Table 1

Default Value 5 Delete Table 3

Drop Table 5 Index 39

Rename Table 1 Table Structure 1

Temporary Table 9 TRUNCATE 3

Join /

Condition JOIN 1 Cross Join 1

Database Join 4 Delete From Join 3

Full Join 3 Function In Join 2

Inner Join 10 Join Delete 3

Join Order 3 Join Select 39

Join Table 7 Join Three Tables 2

Join Update 2 Left Join 22

Right Join 5 Self Join 4

Simple JOIN 20 Using 9

Transaction /

autocommit 4 COMMIT 2

ISOLATION 2 Lock 5

RollBack 4 Savepoint 2

TRANSACTION COMMIT 2 TRANSACTION ROLLBACK 3

Key /

Foreign Key 9 Key 1

Primary Key 19

Engine /

Change 2 CSV 1

Engine Type 3 InnoDB 1

Merge 1 MyISAM 6