Auto Increment continuing from last id

Question

I am currently working on a personal project and i would like to be able to delete SQL and not have autoincrement still go from the last id it was

Use `truncate table`. This will reset the auto increment id as well as removing the contents of the table. — Gordon Linoff, Dec 06 '15 at 16:33

score 0 · Accepted Answer · answered Dec 06 '15 at 16:35

0

This is probably worth an answer.

delete from t

and

truncate table t

are very similar in that they both remove all rows from the the table t. However, truncate table has certain other features, such as:

So, use it to empty your tables and remove all the rows.

The documentation discusses this.

answered Dec 06 '15 at 16:35

Gordon Linoff

didnt need to use delete from t but truncate table t worked thanks – Jackson F. Dec 06 '15 at 16:57

1 Answers1