Jon Shoberg pressed the little lettered thingies in this order...
>
> Is there an SQL query for resetting the autoincrement field of a table ? I
> know myisamchk will do this but the system I am on will not let me us it.
> I can get console level access but that is all. I simply want to reindex
> my data back to the start of 1.
>
Drop the column and re-add it. From the command line MySQL client
tool:
ALTER TABLE table,
DROP increment_column,
ADD increment_column INT UNSIGNED AUTO_INCREMENT NOT
NULL PRIMARY KEY;
If you have other tables referencing the auto_increment field in this
table, you're really going to mess things up regardless of how you
resequence these values. If no other tables interact with this one (or if
you can easily and manually recreate the interactivity), you shouldn't
have any problems.
Christopher Ostmo
a.k.a. [EMAIL PROTECTED]
AppIdeas.com
Meeting cutting edge dynamic
web site needs
For a good time,
http://www.AppIdeas.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
