SELECT
concat(' ALTER TABLE ',TABLE_CONSTRAINTS.CONSTRAINT_SCHEMA,'.',TABLE_CONSTRAINTS.TABLE_NAME,' DROP FOREIGN KEY ',TABLE_CONSTRAINTS.CONSTRAINT_NAME,';')
FROM
TABLE_CONSTRAINTS where CONSTRAINT_TYPE = 'FOREIGN KEY'
AND CONSTRAINT_SCHEMA in ('blossom','blossom_bak')
mysql 删除数据所有外键
最新推荐文章于 2024-05-24 23:35:22 发布