WISHLIST: auto_increment after delete

[Christian Hammers <ch@xxxxxxxxxxx>]

Hello MySQL developers

please add a 
	ALTER TABLE xyz eternal_auto_increment=1;
that forces the auto_increment column to increment regardless of which
table type I use and how I delete my columns. As long as there is a way
to reset the column somehow (by setting it to -1 or so) I would find
this very comfortable. At least it's horror if my column starts behaving
differently if I only change the table type to get COMMIT/ROLLBACK or 
forget to delete with "DELETE FROM xyz WHERE 1;" instead of the normal
"DELETE FROM xyz;".

(Yes I know that all is documented somewhere but still it's hard to use..)

thanks,

 -christian-

-- 
Christian Hammers    WESTEND GmbH - Aachen und Dueren     Tel 0241/701333-0
ch@xxxxxxxxxxx     Internet & Security for Professionals    Fax 0241/911879
           WESTEND ist CISCO Systems Partner - Premium Certified


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92885@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php