AUTO_INCREMENT in InnoDB

2004-02-02 Thread Hassan Shaikh
I can't drop the table. Can't I do without dropping the table? Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AUTO_INCREMENT in InnoDB

2004-02-01 Thread Heikki Tuuri
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 s

AUTO_INCREMENT in InnoDB

2004-02-01 Thread Hassan Shaikh
Hi, How do I reset the AUTO_INCREMENT column to some arbitrary number? My table type is InnoDB. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]