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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php