Here’s the syntax to add auto increment column during table creation. However, remember that auto increment constraint can be assigned only to primary key column.

You can also add auto increment column during table creation.

mysql> insert into sales(amount) values(150),(250) Īs you can see, the MySQL has automatically increased and populated id column with values 7 and 8.īonus Read : How to Find Nth Row in MySQL Next we will add a couple of rows in sales table. MODIFY id INT NOT NULL AUTO_INCREMENT PRIMARY KEY Here’s the SQL statement to add AUTO INCREMENT constraint to id column. In the above statement, you need to specify the table_name and column_name. MODIFY column_name INT NOT NULL AUTO_INCREMENT PRIMARY KEY Here’s the syntax of ALTER TABLE statement, ALTER TABLE table_name Now, we will modify the id column to be auto increment, using ALTER TABLE.īonus Read : Top 5 Free Database Design Tools mysql> create table sales(id int, amount int) Let’s say you have the following sales(id, amount) table. Here are the steps to add auto increment column in MySQL. In this article we will look at how to add auto increment column in MySQL. Auto Increment columns automatically increase in value as you add more rows to the table.

Tableplus add rows