Will int start filling in missing values?

Question

MySQL

Good day! For example, there is a field where the id field will not exceed 127, but the data can be deleted, and new ones can be added, and I'm afraid that when the id reaches 127, it will stop adding or it will start adding those values ​​​​that are not in the id field?

Answer 1

No. If the field is set to TINYINT AUTOINCREMENT, then after reaching 127, an attempt to add a new record will generate an error. Gaps resulting from deleting records or pending transactions are not automatically filled.