mysql只受查詢權力,mysql中怎么看主鍵是誰?
mysql查詢主鍵可通過執行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數據庫'
AND constraint_name='PRIMARY'
上一篇怎么卸載mysql
下一篇數據庫如何設置時間地址
mysql查詢主鍵可通過執行一條語句進行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數據庫'
AND constraint_name='PRIMARY'