You should refer to manual, your case depends on the type of your table.
MyISAM tables do assign new number always, and there's some another kind of
table which is reusing numbers the same way you need. I don't remember what
type exactly, so refer to the manual.
-----Original Message-----
From: Deependra B. Tandukar [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 8:07 AM
To: [EMAIL PROTECTED]
Subject: AUTO INCREMENT Q U E S T I O N in MySQL
Greetings !
Suppose I have a table in MySQL Database:
id Name
-------------------------
1 ABC
2 BBB
3 CAB
like this id being auto_increment. If I delete all the three records and
start with new then it starts from id 4, while I need it to be started from
1.
Can anyone suggest, how can I achieve this?
Looking forward to hear from you soon.
Warm Regards,
DT
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
