Yes, I saw that & tried it, but turned out I was just doing it wrong.
I had an errant SET in my statement. What works is:
ALTER TABLE event AUTO_INCREMENT = 1300
Thanks
Dan
At 2:59 PM + 11/15/05, mel list_php wrote:
I think you want that:
When you add an AUTO_INCREMENT column, colu
mel list_php wrote:
From: Dan Buettner <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Changing range of identity column for future inserts
Date: Tue, 15 Nov 2005 08:50:03 -0600
I would like to change one of my tables so that future inserts use a
higher range of numbers for the primary k
I think you want that:
When you add an AUTO_INCREMENT column, column values are filled in with
sequence numbers for you automatically. For MyISAM tables, you can set the
first sequence number by executing SET INSERT_ID=value before ALTER TABLE or
by using the AUTO_INCREMENT=value table option
