欧美一区二区三区,国内熟女精品熟女A片视频小说,日本av网,小鲜肉男男GAY做受XXX网站

mysql只受查詢權(quán)力,mysql中怎么看主鍵是誰(shuí)

mysql只受查詢權(quán)力,mysql中怎么看主鍵是誰(shuí)?

mysql查詢主鍵可通過(guò)執(zhí)行一條語(yǔ)句進(jìn)行查看:

SELECT

column_name

FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`

WHERE

table_name='要查詢主鍵的表名'

AND CONSTRAINT_SCHEMA='數(shù)據(jù)庫(kù)'

AND constraint_name='PRIMARY'