RE: dropping auto_increment PK/Index

2001-11-15 Thread Carsten H. Pedersen
> 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

Re: dropping auto_increment PK/Index

2001-11-14 Thread Jason Brooke
Maybe you could try insert delayed - Original Message - From: "Wilfred Li, Ph.D." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 9:17 AM Subject: dropping auto_increment PK/Index > Hi, > > Is it possible to drop an auto_increment column index or primary k