List:General Discussion« Previous MessageNext Message »
From:Ph.D. Wilfred Li Date:November 14 2001 11:17pm
Subject:dropping auto_increment PK/Index
View as plain text  
Hi,

Is it possible to drop an auto_increment column index or primary key to
boost performance for bulk inserts? It seems mysql requires auto_increment
columns to be a key at all times.

Here is the error message:

Incorrect table definition; There can only be one auto column and it must
be defined as a key

Thanks

Wilfred

Thread
dropping auto_increment PK/IndexPh.D. Wilfred Li15 Nov
  • Re: dropping auto_increment PK/IndexJason Brooke15 Nov
  • RE: dropping auto_increment PK/IndexCarsten H. Pedersen15 Nov