How to set auto-increment in MySQL fields?

2 years ago
Sophia Anderson
1 minute

To set a MySQL field to auto increment, you need to use the AUTO_INCREMENT keyword in the field definition when creating the table. For example:

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

In the example above, an id field is defined and set as an auto-increment field using the AUTO_INCREMENT keyword, while also defining it as a primary key. This means that the id field will automatically increment when inserting data, without needing to manually specify a value.

bannerAds