说明:FK_PRODUCT_ID代表外键名称,验证是否已存在
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE CONSTRAINT_NAME='FK_PRODUCT_ID'
【额外技能】查看某张表的索引:
show index from portal_product_extends;
说明:FK_PRODUCT_ID代表外键名称,验证是否已存在
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE CONSTRAINT_NAME='FK_PRODUCT_ID'
【额外技能】查看某张表的索引:
show index from portal_product_extends;