Ha ha, thank you for "page 558" but I am blind and I am reading the electronic version of the book. However, I think I've reached to page 558 because I've seen how to do it.
Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Octavian Rasnita" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 9:26 PM Subject: Re: Resetting the auto_increment to start from 1 At 9:33 +0200 1/8/03, Octavian Rasnita wrote: >Hi all, > >I've read the following in a MySQL book: > > A special case of record deletion occurs when you clear out a table >entirely using a DELETE with no WHERE clause: > DELETE FROM tbl_name; > In this case, the sequence counter may be reset to 1, even for table types >for which values normally are not reused (MyISAM and InnoDB). For those >types, if you wish to delete all the records while maintaining the current >sequence value, tell MySQL to perform a record-at-a-time delete by including >a WHERE clause that specifies some trivially true condition: > DELETE FROM tbl_name WHERE 1 > 0; > >--- > >Well, I've tried that sql statement, but the auto_increment point of start >was not reset to 1. Note that the text in question says *may* be reset to 1. To reset it for sure, use the statement at the top of page 558. :-) >I use MySQL 4.05 under Windows 2000. > >Thanks. > >Teddy, >Teddy's Center: http://teddy.fcc.ro/ >Email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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