RE: [PHP] reset auto_increment field mysql

2002-03-13 Thread Claudiu

It continues incrementing the id field from where it left..
But i found the solution on the web;
it's as simple as :
TRUNCATE mytable; (which deletes the contents and also resets
auto_increment field to 0)

Thanks !

On Tue, 12 Mar 2002, Rick Emery wrote:

 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...

 On Tue, 12 Mar 2002, Rick Emery wrote:

  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.
  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 solve this problem..
  I want id to reset to 0 when i delete the contents of the table.
  Can someone help?
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[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 solve this problem..
I want id to reset to 0 when i delete the contents of the table.
Can someone help?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




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.
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 solve this problem..
I want id to reset to 0 when i delete the contents of the table.
Can someone help?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] reset auto_increment field mysql

2002-03-12 Thread Claudiu

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-
 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.
 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 solve this problem..
 I want id to reset to 0 when i delete the contents of the table.
 Can someone help?


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




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-
  From: Claudiu [mailto:[EMAIL PROTECTED]]

  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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




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...

On Tue, 12 Mar 2002, Rick Emery wrote:

 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.
 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 solve this problem..
 I want id to reset to 0 when i delete the contents of the table.
 Can someone help?


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php