flusing the database

[pradeepjain]

hii guys,
I am using a table .which i use it for testing for some times .when it goes live i must flush all the data from it so that the Id counter starts from 1.How to do it.....now i drop the table and then create the table again.any other better method.


thanks,
pradeep

[r035198x]

You can reset the auto increment value for a table using
[CODE=mysql]alter table tableName auto_increment = 1 [/CODE]

[Atli]

You can use the TRUNCATE syntax.

It basically drops and re-creates the table, which also resets the Auto_Increment value.