mysql drop table

SELECT GROUP_CONCAT('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = 'database_name';

select table_name from tables where table_schema='zabbixdb';

SET FOREIGN_KEY_CHECKS = 0;
drop table users;

相关日志