On Mon, 15 Dec 2003, Peter Lovatt wrote: > Try > > Insert INTO `table` ( `inc_field` ) values (1000000000) > > the auto inc field will then generate the next sequential numbers > > HTH > > Peter
Or just use ALTER TABLE table AUTO_INCREMENT=1000000000 That way you don't have to enter a record just to set the AUTO_INCREMENT value. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]