#添加表约束
ALTER TABLE `gd_vedio_comment` ADD CONSTRAINT FOREIGN KEY (vedio_id) REFERENCES `gd_vedio_page_list`(id);
#查询单个表约束
SELECT
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_NAME = 'gd_vedio_comment';
#查询所有约束
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
mysql的表约束添加和查看
最新推荐文章于 2024-08-12 22:13:41 发布