Query : ALTER TABLE `test`.`quest` DROP PRIMARY KEY
Error Code : 1075
Incorrect table definition; there can be only one auto column and it must be defined as a key
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
ALTER TABLE `quest_need_monster` DROP PRIMARY KEY
提示什么
SELECT * FROM information_schema.`TABLES` a
INNER JOIN `KEY_COLUMN_USAGE` b ON a.TABLE_NAME=b.TABLE_NAME
WHERE a.TABLE_NAME like '%`quest_need_monster`%'AND CONSTRAINT_NAME='PRIMARY'
结果是什么
取得约束名
SELECT * FROM information_schema.`TABLES` a
INNER JOIN `KEY_COLUMN_USAGE` b ON a.TABLE_NAME=b.TABLE_NAME
WHERE a.TABLE_NAME like '%te%'AND CONSTRAINT_NAME='PRIMARY'