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

Reply via email to