从mysql查询 mysql中怎么看主键是谁 – 数据库 – 前端 mysql连接1045错误

SELECT

column_name

FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`

WHERE

table_name=要查询主键的表名

AND CONSTRAINT_SCHEMA=数据库

AND constraint_name=PRIMARY