| 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/Index | Ph.D. Wilfred Li | 15 Nov |
| • Re: dropping auto_increment PK/Index | Jason Brooke | 15 Nov |
| • RE: dropping auto_increment PK/Index | Carsten H. Pedersen | 15 Nov |
