mysql 删除所有表
#use information_schema;
#select concat('drop table ',table_name,';') from tables where TABLE_SCHEMA = 'nxpt';
拼接删除SQL
#select concat('TRUNCATE table ',table_name,';') from tables where TABLE_SCHEMA = 'nxpt';不写日志
SET FOREIGN_KEY_CHECKS=0;#取消外键约束状态
古之善为士者,微妙玄通,深不可识