On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia [EMAIL PROTECTED] wrote:
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
mysql *ALTER TABLE tbl AUTO_INCREMENT = 100;*
On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain [EMAIL PROTECTED] wrote:
Hello friends,
I need to reset
abhishek jain wrote:
On Sat, Aug 2, 2008 at 10:49
But as per a thread on this link, if the resetted value is less than the
highest value already in table then the effective increment value will start
from highest number and not from 100.
I have deleted some rows and i want the increment to
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the value that you
Chris W wrote:
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the
At 21:00 -0500 12/29/02, Carlin Anderson wrote:
I have a number of databases installed under mysql 3.23 and 4.0, and
will need to occasionally re-initialize certain tables. Can I
re-set auto-increment fields within those tables?
You can drop and re-create the tables. This will work for any
I just saw this in the manual and think it can do what you need:
It's an option of the myisamchk program
--set-auto-increment[=value]
Force auto_increment to start at this or higher value. If no value is given,
then sets the next auto_increment value to the highest used value for the
auto key +
At 6:03 PM -0500 9/25/01, [EMAIL PROTECTED] wrote:
Hi All,
I seen a post a few days ago on how to set the auto increment value
back to one
after deleting all the data from a table. I suppose I could just re-create the
table, but thought it be simpler to just alter the table to reset the auto
