mysql 查詢執(zhí)行掛起,mysql中怎么看主鍵是誰?
mysql查詢主鍵可通過執(zhí)行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數(shù)據(jù)庫'
AND constraint_name='PRIMARY'
mysql查詢主鍵可通過執(zhí)行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數(shù)據(jù)庫'
AND constraint_name='PRIMARY'