andrescevp · September 27, 2017 07:42
diff --git a/disable_enable_foreign_keys_check.sql b/disable_enable_foreign_keys_check.sql
 SET FOREIGN_KEY_CHECKS=0; #disable
 SET FOREIGN_KEY_CHECKS=1; #enable
diff --git a/dump_mysql_schema.sh b/dump_mysql_schema.sh
 mysqldump --opt --single-transaction --no-data --disable-keys -u <user> -h <host> -p DB
diff --git a/search_columns_information.sql b/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;
diff --git a/select_last_24_hours.sql b/select_last_24_hours.sql
 SELECT * FROM news WHERE date >= now() - INTERVAL 1 DAY;
	SET FOREIGN_KEY_CHECKS=0; #disable
	SET FOREIGN_KEY_CHECKS=1; #enable
	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;