查詢員工號mysql,mysql中怎么看主鍵是誰?
mysql查詢主鍵可通過執行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數據庫'
AND constraint_name='PRIMARY'
mysql查詢主鍵可通過執行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數據庫'
AND constraint_name='PRIMARY'