MySQL INSERT INTO SELECT into a table with AUTO_INCREMENT

Let us create a table −

mysql> create table DemoTable1923    (    UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    UserName varchar(20)    ); Query OK, 0 rows affected (0.00 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable1923(UserId,UserName)      select 101 as UserId,'Chris' as UserName; Query OK, 1 row affected (0.00 sec) Records: 1  Duplicates: 0  Warnings: 0 mysql> insert into DemoTable1923(UserId,UserName)     select 102 as UserId,'Robert' as UserName; Query OK, 1 row affected (0.00 sec) Records: 1  Duplicates: 0  Warnings: 0 mysql> insert into DemoTable1923(UserId,UserName)     select 103 as UserId,'Sam' as UserName; Query OK, 1 row affected (0.00 sec) Records: 1  Duplicates: 0  Warnings: 0

Display all records from the table using select statement −

mysql> select * from DemoTable1923;

This will produce the following output −

+--------+----------+ | UserId | UserName | +--------+----------+ |    101 | Chris    | |    102 | Robert   | |    103 | Sam      | +--------+----------+ 3 rows in set (0.00 sec)