How to reset auto_increment back to zero

Hi,

I have a table that I'm experimenting with learning. I am constantly deleting all the records from this table and then re-updating with new data. I can't figure out how to reset the auto_incrementing without dropping the table entirely and re-creating it.

Is there a SQL command to reset to 0 each time I delete all the records to start fresh?:confused:

you mean deleting all the data inside your table?

lilke this?

DELETE * FROM tbl_name

i have really small knowledge about my_sql harhar

Try dropping and recreating the index. I think the Index tells the query the next auto inc value.

Why not just truncate the table instead. That will delete the data and reset the auto_increment counter for the table.

The SQL syntax for TRUNCATE TABLE: TRUNCATE TABLE "table_name"

So, too truncate the table called products simply type:

TRUNCATE TABLE products

see ya :wave:

ALTER TABLE table_Name AUTO_INCREMENT=1;

that works!

Thank's guy's. All good suggestions

I guess I really do not understand how the MySQL auto_increment counter works.