批量删除表(sql):
select concat
('drop table ' , table_name,';')
from
information_schema.tables
where
table_schema = '数据库名';
如果有外键(解决办法1):
set foreign_key_checks = 0 ;
上面的(sql);
set foreign_key_checks = 1;
======================================================
如果有外键(解决办法2),批量删除外键:
select concat('ALTER table ',a.TABLENAME ,' drop foreign key ', a.CONSTRAINTNAME , ';')
from
(select t.constraint_name CONSTRAINTNAME, t.table_name TABLENAME
from information_schema.TABLE_CONSTRAINTS t
where t.table_schema = '数据库名' and t.constraint_type = 'FOREIGN KEY') a
然后,上面的(sql);
这么好的文章我给自己一个赞 *_* ;