Is it possible to drop a primary key index in MySQL (version 5.1.47).
This is to optimize the insert performance.开发者_开发知识库
If you're sure this is what you want to do (note Paul Tomblin's comment on your question), then from the ALTER TABLE
docs:
ALTER TABLE `tablename` DROP PRIMARY KEY;
DROP PRIMARY KEY drops the primary key. If there is no primary key, an error occurs.
精彩评论