In first MySQL statement, you will remove the auto-increment from the column and in second statement, you will again declare the field as autoincrement. This way the auto increment counter will reset ...

The AUTO_INCREMENT keyword is used to increment value in MySQL, by default it's starting value is 1 and increments by 1 every time when a new record is inserted.

The usage above is the same as that of AUTO_INCREMENT in MySQL. However, in terms of the specific value that is implicitly assigned, TiDB differs from MySQL significantly.

This is related to me learning Django but it's specific to MySQL so I'll treat it as such.I need a table that includes:id - primary key (auto increment)text - object descriptionversion - version ...

If you do want to delete stuff MySQL shouldn't reuse the auto_inc. DO NOT reset the database unless you've been doing testing and such and are now going live (and even then it's questionable).