Loading...

Skip to main content

MySQL Reference

Data Types

Numeric
Character
Date /Time
Binary

Functions

System Date
Convert Date
Lower Case
Upper Case
Add (Subtract) to a Date

DBA

Explain
Analyse (single and/or multiple tables)
Describe Table
List Tables
List Indicies

Advanced

Comment
Surrogate Keys
Stored Procedures
Triggers
Java Class
Send an Email
Write to a File
Capture output to a file

DDL

Create
Create w/ Primary Key
Create w/ Auto Increment
Create Temp Table
Alter (delete a field)
Alter (change size)

DML

Update (Large number of rows)
select
select w/ WHERE date
select w/ WHERE IN
select w/ sub-query
select w/ UNION
Insert
Insert INTO

Optimize Database

mysqlcheck -o <database name> -u <userid> -p<password>

Reset Auto Increment Number

ALTER TABLE table_name AUTO_INCREMENT = {new_number}

History Comments