RE: [PHP] reset auto_increment field mysql

2002-03-13 Thread Claudiu
you get? -Original Message- From: Claudiu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 8:51 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] reset auto_increment field mysql I wish it was that simple... No.. It doesn't work this way... On Tue, 12 Mar 2002, Rick Emery wrote

[PHP] reset auto_increment field mysql

2002-03-12 Thread Claudiu
I have a mysql table which contains an id field which is set to auto_increment. I have a script which empties this database at regular intervals. My problem is that the auto_increment field won't reset to 0 after deleting all of tha data, but continue incrementing from where it left. How can i

RE: [PHP] reset auto_increment field mysql

2002-03-12 Thread Rick Emery
your query is: DELETE FROM mytable; -Original Message- From: Claudiu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 5:09 AM To: [EMAIL PROTECTED] Subject: [PHP] reset auto_increment field mysql I have a mysql table which contains an id field which is set to auto_increment

RE: [PHP] reset auto_increment field mysql

2002-03-12 Thread Claudiu
auto_increment field mysql I have a mysql table which contains an id field which is set to auto_increment. I have a script which empties this database at regular intervals. My problem is that the auto_increment field won't reset to 0 after deleting all of tha data, but continue incrementing

RE: [PHP] reset auto_increment field mysql

2002-03-12 Thread Matt Schroebel
How about: ALTER table auto_increment=0 -Original Message- From: Claudiu [mailto:[EMAIL PROTECTED]] I wish it was that simple... No.. It doesn't work this way... On Tue, 12 Mar 2002, Rick Emery wrote: your query is: DELETE FROM mytable; -Original Message-

RE: [PHP] reset auto_increment field mysql

2002-03-12 Thread Rick Emery
It worked for me. What results did you get? -Original Message- From: Claudiu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 8:51 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] reset auto_increment field mysql I wish it was that simple... No.. It doesn't work this way