> 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
The following should do the trick: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_12_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
