I
I
IvanN7772018-05-15 15:55:32
MySQL
IvanN777, 2018-05-15 15:55:32

Mysql how to make id only grow?

I have a small database and a very ancient site.
It has a lot of bugs.
If, for example, the product is deleted.
It will be difficult to restore it, since another one may take its place.
The idea is that if the id of new entries will constantly add a number, it will be easier for me to find errors.
And remove them from the backup.
Since the new entries do not overlap the old ones.
Is it possible to somehow configure Mysql so that the id constantly goes up.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Entelis, 2018-05-15
@IvanN777

AUTO_INCREMENT

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question