查询schema下面所有表，并删除

select * from information_schema.tables where table_schema='public' ；

清空具有外键约束的表时报ERROR 1701(42000)的解决

 

   ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key
constraint (`furion`.`tbl_frn_alert`, CONSTRAINT `FK353A3CBEB139CC08`
FOREIGN KEY (`endpt_id`) REFERENCES `furion`.`tbl_frn_endpt` (`id`))

  www.2cto.com  

解决方法：

 

mysql> SET foreign_key_checks=0;

 

 删除后

 

mysql> SET foreign_key_checks=1;