mysql只受查詢權(quán)力,mysql中怎么看主鍵是誰(shuí)?
mysql查詢主鍵可通過(guò)執(zhí)行一條語(yǔ)句進(jìn)行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數(shù)據(jù)庫(kù)'
AND constraint_name='PRIMARY'
mysql查詢主鍵可通過(guò)執(zhí)行一條語(yǔ)句進(jìn)行查看:
SELECTcolumn_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE`
WHERE
table_name='要查詢主鍵的表名'
AND CONSTRAINT_SCHEMA='數(shù)據(jù)庫(kù)'
AND constraint_name='PRIMARY'