Current lesson | Lesson 4/24

AUTO INCREMENT Primary Keys in MySQL

From ER Diagram to MySQL: Your Complete Learning Path 0%
Let's look at AUTO INCREMENT primary keys in MySQL. I'll show you how to define them in CREATE TABLE, how MySQL automatically assigns an incrementing value to each new record, and how to verify auto-increment behavior with SELECT after INSERT INTO.
Instructor
Up next The One-to-Many Relationship in the ER Diagram