You can change the table definition to not have the auto_increment column, and then ALTER TABLE MODIFY COLUMN after that. However, if you post your errors here, perhaps you'll get the answer that actually solves the problem, instead of working around it to possibly leave bad data for you to discover later on?
-Sheeri On 2/3/06, Scott Johnson <[EMAIL PROTECTED]> wrote: > Hi All, > > I'm trying to restore a database where the first column is set to > auto_increment. When I apply the inserts created from the mysqldump I get > errors about the auto_increment column. Is there a may to turn it off while > I run the inserts or do I have to modify the table? > > Thanks, > > Scott Johnson > [EMAIL PROTECTED] > Tel.: (514) 917-4922 > Fax: (514) 673-0011 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]