Does the mySQL server reuse primary key IDs that are on autoincrement?

Question

E.g. in the users table a user deletes his account which has an ID of 5 - will mysql ever fill in 5 again?

Answer 1

No unless ofcourse you drop the table and recreate it!
Auto-increment values keep on increasing. So if the table has 1000 rows and id 5 is deleted, the next row added would be 1001 and NOT 5!

Answer 2

If the field of your sample database table is an auto-increment, the database will automatically assign in the next available id number (starting with increment of 1, unless you specify otherwise)

Answer 3

there would properly be in reality one 'undemanding key' in a table. attempt, CREATE table VIOLATIONCITATION (ViolationCitationID Int undemanding KEY, VIOLATIONID CHAR(5) REFERENCES VIOLATION(VIOLATIONID), CITATIONID CHAR(5) REFERENCES quotation(CITATIONID), FINECHARGED DECIMAL(5,2) );

Answer 4

No