AUTO_INCREMENT value

[1BIZLIST]

Hi all,

Does anyone know of a command that clears data from a table and also resets any auto-increment values to 0, I am using DELETE at the moment, but that does not reset the auto_increment.

Or other than that is there a variable that I can use to UPDATE the AUTO_INCREMENT value?

I'm using php and mySQL.

Many Thanks

[andy2004]

mysql_query("TRUNCATE TABLE `table_name`");

[1BIZLIST]

Aaahhh! exactly what I was looking for I had tried most variations of that as it is the command shown in phpmyadmin, but couldn't quite get it.

Thanks very much.

Mark.