INSERT INTO t_user (username,password,age)
VALUES
('djpp','5566',21),
('djaa','5988',23),
('djbb','6100',25),
('yypp','801.',28),
('yypp','9827',28);
INSERT INTO t_user(id,age,username)
UNION all
select 18,31,'llza'
UNION all
select 19,39,'kd'
UNION all
select 20,19,'bd6'
UNION ALL
select 21,21,'6nz'
UNION all
select 22,22,'llza'
UNION ALL
select 19,31,'mml'
UNION all
select 23,24,'9aa'
标签:INSERT,21,批量,UNION,22,19,添加,SQL,select
From: https://www.cnblogs.com/Lake-Chen/p/16617929.html