Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

[PHP-DB] Re: easy db question From: Angela Curtis (angela <email protected>)
Date: 04/03/01

Are you deleting them one by one? If you set a condition for the
deleting, then the auto_increment value won't go back to zero, but if
you just delete all it will.
For example, if you say:
delete from my_table where 1>0;
it won't reset the value.
But if you just say:
delete from my_table;
it should reset the value to zero.

-Angela

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>