In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Name: In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.
Brand: Quizplus
Rating: 4.9 (38 reviews)

Question

Quizplus · Accepted Answer

MySQL does not have a data type of IDENTITY. The equivalent data type in MySQL is AUTO_INCREMENT. Therefore, surrogate keys that use a sequence maintained by MySQL should be given a data type of AUTO_INCREMENT.

In MySQL,surrogate Keys That Use a Sequence Maintained by MySQL