INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt) VALUES ('col1001','部门编号',10,'not null','y') INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt) VALUES ('col1002','部门名称',20,'not null','y')
记录量很多也可用: INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt) select 'col1001','部门编号',10,'not null','y' union all select 'col1002','部门名称',20,'not null','y' union all select .............. ....................... (好象省了几个字母)
INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt) VALUES ('col1001','部门编号',10,'not null','y'), INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt) VALUES('col1002','部门名称',20,'not null','y') j9988(j9988) 的方法叫我长见识!!
同意cyberwizard() ! 那样做和一条条insert有什么区别
select 'col1001','部门编号',10,'not null','y' union all select 'col1002','部门名称',20,'not null','y' union all select ..............要进行笛卡儿积操作,可能要耗掉一点时间的。还不如直接用两条insert。
VALUES ('col1001','部门编号',10,'not null','y')
INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt)
VALUES ('col1002','部门名称',20,'not null','y')
INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt)
select 'col1001','部门编号',10,'not null','y'
union all select 'col1002','部门名称',20,'not null','y'
union all select ..............
.......................
(好象省了几个字母)
VALUES ('col1001','部门编号',10,'not null','y'),
INSERT INTO bmzdxx (zdywmc,zdzwmc,zdcd,yxk,xt)
VALUES('col1002','部门名称',20,'not null','y')
j9988(j9988) 的方法叫我长见识!!
那样做和一条条insert有什么区别
union all select 'col1002','部门名称',20,'not null','y'
union all select ..............要进行笛卡儿积操作,可能要耗掉一点时间的。还不如直接用两条insert。