Updated: 20 September 2022
Show columns statement
SHOW COLUMNS FROM City;
Query for big tables
SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "my_table" ORDER BY (data_length + index_length) DESC;
Disable foreign key checks
SET foreign_key_checks = 0; SET foreign_key_checks = 1;