mysql怎么看约束和触发器？

可以从information_schema架构下的系统表查看\x0d\x0a \x0d\x0a-- 查看约束\x0d\x0aSELECT * FROM information_schema.`TABLE_CONSTRAINTS`\x0d\x0a \x0d\x0a-- 查看触发器\x0d\x0aSELECT * FROM information_schema.`TRIGGERS`

可以从information_schema架构下的系统表查看

-- 查看约束

SELECT * FROM information_schema.`TABLE_CONSTRAINTS`

-- 查看触发器

SELECT * FROM information_schema.`TRIGGERS`

---