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 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php