MySQL Things

MySQL Doc 

• http://dev.mysql.com/doc/

MySQL Tools

• http://www.percona.com/downloads/

Common Commands

Show Databases;

show processlist;
show events;

Show Tables;

Describe TABLE_NAME; 

NO LOCK

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM TABLE_NAME ;
COMMIT ;

SQL (Agent) JOB 

SET GLOBAL event_scheduler = ON;

http://www.sitepoint.com/how-to-create-mysql-events/

TEMP TABLE

CREATE TEMPORARY TABLE IF NOT EXISTS tmp_C AS (SELECT * FROM `Carrier`);

select * from tmp_C;

VARIABLE

select @CarrierId :=  Id from TableName where `Name` = 'T';