MySQLSnippets.md

My SQL Snippets

Process List

SHOW PROCESSLIST

DROP all tables

SELECT concat('DROP TABLE IF EXISTS `', table_schema, '`.`', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'DATABASE_NAME_HERE';

Then use:

SET FOREIGN_KEY_CHECKS = 0;

-- COPY AND PASTE LIST FROM ABOVE SQL

SET FOREIGN_KEY_CHECKS = 1;

EXPLAIN how indexes are used in a SELECT

EXPLAIN SELECT * FROM my_table;