一,
有个表student,两个字段Sname和Age,values 一次搞一条,想搞多条用select ...union select...结果集;
单条插入
INSERT
INTO
student (Sname,Age)
VALUES
(
'王五'
,17)
INSERT
INTO
student (Sname,Age)
VALUES
(
'赵'
,18)
或者一次多行插入
INSERT
INTO
student (Sname,Age)
select
'王五'
,17
union
all
select
'赵'
,18