MySQL Cheat Querys

disable_enable_foreign_keys_check.sql

SET FOREIGN_KEY_CHECKS=0; #disable
SET FOREIGN_KEY_CHECKS=1; #enable

dump_mysql_schema.sh

mysqldump --opt --single-transaction --no-data --disable-keys -u <user> -h <host> -p DB

search_columns_information.sql

select * from information_schema.columns
where table_schema = 'db' AND
COLUMN_NAME like '%foo%' 
#AND TABLE_NAME like '%foo%'
order by table_name,ordinal_position;

select_last_24_hours.sql

SELECT * FROM news WHERE date >= now() - INTERVAL 1 DAY;