MySQL Syntax
CREATE DATABASE [ IF NOT EXISTS ] db_name;
SHOW GRANTS FOR 'user';
REVOKE grant_name ON db_name.* FROM 'user';
GRANT ALL ON db_name.* TO 'user';
CREATE [ TEMPORARY ] TABLE [ IF NOT EXISTS ] tbl_name
( field_names data_type [ DEFAULT default_value ],
  CONSTRAINTs );
DROP TABLE IF EXISTS tbl_name;
INSERT INTO tbl_name VALUES
( all field values ),( all field values );
INSERT INTO tbl_name
load data from existing db with select statement
INSERT INTO tbl_name( field_values ) VALUES
( some field values ),( some field values );
unassigned fields take default values
INSERT INTO tbl_name (field_values)
load specific fields from existing db
DELETE FROM tbl_name
WHERE where_condition;
section 12.2.2 DELETE Syntax
TEE file_name;
SOURCE file_name;
USE db_name;
SHOW TABLES;
DESCRIBE tbl_name;
SHOW DATABASES;
ORDER BY field;
SELECT fields FROM tbl_name WHERE conditions;
UPDATE tbl_name
SET col_name=expr1, col_name2=exp2
WHERE where_condition
SELECT CURDATE();
SELECT 'yyyy-mm-dd' + INTERVAL 10000 DAY (year, month, second, minute, etc.);
SELECT DATE_ADD( 'yyyy-mm-dd', INTERVAL 10000 DAY );
SELECT ADDDATE( 'yyyy-mm-dd', INTERVAL 10000 DAY );
SHOW STATUS;
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_key_buffer_size
SHOW VARIABLES;
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
SET STORAGE_ENGINE=MyISAM;
SET STORAGE_ENGINE=InnoDB;
http://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb
SET GLOBAL key_buffer_size=4*1024*1024
http://dev.mysql.com/doc/refman/5.0/en/structured-system-variables.html
shell> mysqld_safe --key_buffer_size=64M
--table_open_cache=256 \
--sort_buffer_size=4M
--read_buffer_size=1M &


Valid HTML 4.01 Strict