SQL中批量添加数据的两种人,疯狂!!!

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'

浙公网安备 33010602011771号