色婷婷狠狠18禁久久YY,CHINESE性内射高清国产,国产女人18毛片水真多1,国产AV在线观看

mysql查詢所以表,mysql中怎么看主鍵是誰

mysql查詢所以表,mysql中怎么看主鍵是誰?

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

SELECT

column_name

FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`

WHERE

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

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

AND constraint_name='PRIMARY'