AUTO_INCREMENT columns must be NOT NULL.
(a) True
(b) False
This question was posed to me at a job interview.
This intriguing question comes from Choosing Data Types in chapter Data Types of MySQL
(a) True
(b) False
This question was posed to me at a job interview.
This intriguing question comes from Choosing Data Types in chapter Data Types of MySQL
Correct answer is (a) True
The best explanation: The ‘AUTO_INCREMENT’ columns must be NOT NULL. If the NOT NULL is omitted, MySQL adds it automatically. AUTO_INCREMENT column values begin with 1 and increase monotonically after it.