orders<\/em> with id column having AUTO_INCREMENT constraint.<\/p>\n\n\n\nmysql> create table orders(
id int auto_increment,
primary key(id),
product_name varchar(255),
order_date date
);<\/pre>\n\n\n\nLet us say you insert the following data in the above table.<\/p>\n\n\n\n
mysql> insert into orders(product_name,order_date)
values('A','2024-10-28'),
('B','2024-10-29'),
('C','2024-10-30');
mysql> select * from orders;
+----+--------------+------------+
| id | product_name | order_date |
+----+--------------+------------+
| 1 | A | 2024-10-28 |
| 2 | B | 2024-10-29 |
| 3 | C | 2024-10-30 |
+----+--------------+------------+<\/pre>\n\n\n\nAs you can see, the ID column has been auto populated with unique sequential numbers. When you insert another row in the above table, MySQL will automatically assign id=4 for this new row. But if you delete a row and add a new row then ID will still be assigned value 4. What if you do not want it to be this way? We will see several ways to control the value of auto increment below.<\/p>\n\n\n\n