mysql & autoincrement - Databases forum at WebmasterWorld - WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

mysql & autoincrement

how to clear auto increment

malcolmcroucher

11:14 am on Nov 29, 2007 (gmt 0)

10+ Year Member

does anyone know how to clear auto increment?

after having been tested?

Habtom

11:18 am on Nov 29, 2007 (gmt 0)

WebmasterWorld Senior Member

10+ Year Member

Mysql
Under Operations, there is a feature => auto_increment

phranque

12:52 pm on Nov 29, 2007 (gmt 0)

WebmasterWorld Administrator

10+ Year Member

Top Contributors Of The Month

in sql:
ALTER TABLE tablename AUTO_INCREMENT=1;

malcolmcroucher

12:58 pm on Nov 29, 2007 (gmt 0)

10+ Year Member

Thanks!