AUTO INCREMENT Primary Keys in MySQL

Giovanni Pace

Description

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.