Menu
I need to reset my table counter back to 0 - is there a MySQL command for this?
332
The first element of arrays (in most programming languages) has an id (index) of 0. The first element (row) of MySQL tables has an (auto incremented) id of 1.
In MySQL, the syntax to reset the AUTO_INCREMENT column using the ALTER TABLE statement is: ALTER TABLE table_name AUTO_INCREMENT = value; table_name. The name of the table whose AUTO_INCREMENT column you wish to reset.
Indexes help to search for rows corresponding to a WHERE clause with particular column values very quickly so if the index is not working properly, then we must use the REINDEX command to operate and rebuild the indexes of table columns to continue the access of data.
The TRUNCATE TABLE statement removes all the data from a table and resets the auto-increment value to zero.
That's easy:
ALTER TABLE tablename AUTO_INCREMENT=0; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
