ALTER TABLE scm_acceptance DROP FOREIGN KEY FK_ptihrmuk40ri92c82avx32ogl (对应inputOrderUserId字段KEY名)
删除inputOrderUserId字段
ALTER TABLE scm_acceptance DROP COLUMN inputOrderUserId
更新下面语句
UPDATE scm_acceptance a,scm_order b SET a.orderUserId = b.inputUserId WHERE a.orderId = b.id
mysql 移除外键字段
最新推荐文章于 2024-06-04 00:00:08 发布