Table Index Reset

[jenniferG]

We  have an auto-incrementing  index field in a table we ujse for development. when

we deploy, we would like to  remove rows and reset the auto-increment field so the

first row our clients insert will have the auto-increment value  equal to 1;

Thanks,

Natalie

[KrisNz]

TRUNCATE does just that.

[pocobueno1388]

Just to build on the previous post:

 

<?php

mysql_query("TRUNCATE table table_name");

?>