加载中...

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'
posted @ 2023-01-14 16:15  以后只能做  阅读(35)  评论(0)    收藏  举报