Deleting Table Contents

[millsy007]

Hi, I want to delete the contents of my table so that when I add a new row after my auto increment index starts again at 1, how do I achieve this?

[WingedPanther]

You mean "DELETE FROM table"?

[Orjan]

you can also do "TRUNCATE TABLE tablename", that resets auto_increment counter from version 5.0.13 of mysql