EN
MySQL - Create table with AUTO_INCREMENT field
0 points
In this article, we would like to show you how to create table with AUTO_INCREMENT field in MySQL.
Quick solution:
xxxxxxxxxx1
CREATE TABLE `users` (2
`column1` DATATYPE AUTO_INCREMENT,3
`column2` DATATYPE,4
`columnN` DATATYPE,5
PRIMARY KEY (`column1`)6
);Note:
Go to the official documentation to see available
DATA_TYPES.
In this example, we create users table with auto-increment id column which is also the PRIMARY_KEY field.
Note:
AUTO INCREMENTfield is often thePRIMARY KEYfield.
Query:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`username` VARCHAR(50) NOT NULL,4
`group_id` INT(10),5
PRIMARY KEY (`id`)6
);Result:
Now, when we insert into the table, we don't need to specify the id column, it will be added automatically based on the previous number.
Query:
xxxxxxxxxx1
INSERT INTO `users`2
(`username`, `group_id`)3
VALUES4
('user1', 1),5
('user2', 1),6
('user3', 2),7
('user4', 2);Result:
