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

還有一個(gè)本辦法就是

一個(gè)一個(gè)的找到主鍵然后外鍵約束，然后執(zhí)行，表或者數(shù)據(jù)的操作

?

轉(zhuǎn)載于:https://www.cnblogs.com/rocky-AGE-24/p/6753470.html

總結(jié)

以上是生活随笔為你收集整理的处理有外键约束的数据的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。