22,207
社区成员
发帖
与我相关
我的任务
分享
create table student
(
sname varchar(20),
age int
)
INSERT INTO student
select '王五',17
union all
select '赵',18
select *
from student
drop table student
INSERT INTO student (Sname,Age)
VALUES ('王五',17)
INSERT INTO student (Sname,Age)
VALUES ('赵',18)
or
INSERT INTO student (Sname,Age)
select '王五',17 union all
select '赵',18
INSERT INTO student (Sname,Age)
select '王五',17
union select '赵' ,18
INSERT INTO student (Sname,Age)
select '王五',17 union all select
('赵',18)