Stefan, ----- Original Message ----- From: ""Stefan Sturm"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 01, 2002 1:49 PM Subject: MySQL and Autoincrement
> Hello, > > when I use autoincrement on a field, now can I start the count whith > 1000000? with InnoDB tables you have to use the following trick to init the auto-inc counter to 1000000: INSERT INTO table (999999, ...); DELETE FROM table WHERE yourautoinccolumn = 999999; > Thank you, > > Stefan Sturm Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > ----------- > sql, query --------------------------------------------------------------------- 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