Hassan, ----- Original Message ----- From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, February 01, 2004 5:01 PM Subject: AUTO_INCREMENT in InnoDB
> Hi, > > How do I reset the AUTO_INCREMENT column to some arbitrary number? My > table type is InnoDB. drop the table, recreate it, insert a dummy row with the auto-inc column set to the desired value minus 1, and delete that dummy row. > Thanks. > > Hassan Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
