MYSQL Cheat Sheet
MYSQL Design
Database Commands
MYSQL Data
Datatypes
Manipulation
SHOW DATABASES;
TINYINT
Database > Table(s) > Data
MALLINT
INSERT INTO tablename (
CREATE DATABASE databasename;
MEDIUMINT
columnname1,
Table Columns:
INT
columnname2
Limit: 4096 Columns/Table
USE databasename;
BIGINT
) VALUES (
Each Column Identified By Name
CHAR()
'data',
A Datatype Must Be Specified For
DROP DATABASE databasename;
VARCHAR()
'data'
Each Column
TINYTEXT
);
DROP DATABASE IF EXISTS
TEXT
Table Rows:
databasename;
MEDIUMTEXT
SELECT * FROM tablename;
Rows Are Added As New Data Is
LONGTEXT
Stored
DATETIME
Table Commands
SELECT * FROM tablename
Data Is Limited By Column
DATE
WHERE columnname LIKE 'data';
Datatype
TIMESTAMP
Each Row Should Be Uniquely
TIME
CREATE TABLE tablename (
SELECT columnname1,
Identifiable
YEAR
columnname1 DATATYPE,
columnname2 FROM tablename;
columnname2 DATATYPE,
columnname3 DATATYPE,
MYSQL Syntax
UPDATE tablename
PRIMARY KEY(columnname)
SET columnname = 'data'
);
WHERE columnname = 'data';
Statements Must End With
Semicolons (;)
SHOW TABLES;
DELETE FROM tablename
WHERE columnname = 'data';
Reserve Words Can Be Capitalized
DESCRIBE tablename;
SELECT, FROM, AND, LIKE, Etc.
DROP TABLE tablename;
Connecting/Disconnect
DROP TABLE IF EXISTS tablename;
mysql h host u username p
quit