Dear all, I have an auto_increment value in an innodb table. I recently introduced a new row by mistake and removed it. I beleive I read somewhere in the manual that an innodb table does not reuse this number by default. I also remember vaguely that it is possible to reset this next autoincrement value (I want the next insert to reuse this number). I cannot find it in the manual now I need it.
I'm only on the digest list so please (b)cc to me directly. Gerben Gieling Patent Information Specialist Synthon BV P.O. Box 7071 6503 GN Nijmegen The Netherlands phone: +31 24 3727700 fax: +31 24 3727789 E-mail: mailto:[EMAIL PROTECTED] Internet: www.synthon.nl ----------------------------------------------------------------------- DISCLAIMER: This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. Synthon shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. Synthon does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ----------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
