On Sun, 12 Oct 2003 11:27:01 GMT, Nico v. Rossum <n.*********@chello.nl>
wrote:
Hi *,
How can I reset a AUTOINCREMENT column so it starts from 1 to n.
TIA
Hello.
To reset a autoincrement columns I use this:
ALTER TABLE $table AUTO_INCREMENT = 1
Rune Madsen