处理有外键约束的数据

mysql

SET FOREIGN_KEY_CHECKS = 0;
    
delete from  approval_info;
delete from approval_manage;
delete from site_message;
delete from works;
delete from works_theme;
SET FOREIGN_KEY_CHECKS = 1;

oracle drop tablename no CONSTRAINT

还有一个本办法就是

一个一个的找到主键然后外键约束，然后执行，表或者数据的操作