MYSQL DATABASE INTERVIEW QUESTIONS

What is the AUTO_INCREMENT attribute in MySQL?

What does 'auto increment' mean in MySQL?

How do you add an auto increment to a column in MySQL?

What happens to the auto increment value if a row is deleted from a table?

How does MySQL handle the auto increment value in cases of server restarts or crashes?

Is it possible to set a custom starting value for auto increment in MySQL? How?

How does the auto increment behavior change with composite primary keys?

Can you have multiple auto increment columns in a single table in MySQL?

Discuss the implications of large deletions on auto increment columns in MySQL and potential performance impacts.

In a high-availability environment with multiple database replicas, how does MySQL ensure that auto increment values are unique across all replicas?