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

Expand|Select|Wrap|Line Numbers

alter table tableName auto_increment = 1

Atli

You can use the TRUNCATE syntax.

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

flusing the database

re: flusing the database

re: flusing the database

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about