How I can reset the start value for an id in MySQL

[Ducu]

Hi,

This question is about MySQL. I have a field key in my table that I declare as primary key with autoincrement attribute.
After some testing work I decided to delete all records and I was expecting that the counting to start at 1. Wrong!!!
The first id value starts at the next value before cleaning the table.

How I can make the value starts at 1 ? when the table is empty after several cleaning.

 

[Ducu]

Hi,

I found the solution reading the MySQL book.
When you delete the records one by one it doesn't restart the sequence from 1.
You need a DELETE FROM table; instruction to restart the sequence from 1.

Sorry !