一次插入多行数据
我在查询分析器中用：
Create Table employees
(emp_id int primary key,
last_name varchar(25),
trainner varchar(25),
sales int);
建立了一个表。
然后，插入记录：
Insert Into employees(emp_id,last_name,trainner,sales)
Values(1, 'Hardy ', 'Bob ',3),
(2, 'Wallace ', 'Greg ',3),
(3, 'Green ', 'Bob ',2),
(4, 'Marsh ', 'Andy ',2),
(5, 'Brown ', 'Greg ',0);
分析查询有语法错误,想一次插入多条记录,应该怎么做？
[解决办法]
Insert Into employees(emp_id,last_name,trainner,sales)
select 1, 'Hardy ', 'Bob ',3 union all
select 2, 'Wallace ', 'Greg ',3 union all
select 3, 'Green ', 'Bob ',2 union all
select 4, 'Marsh ', 'Andy ',2 union all
select 5, 'Brown ', 'Greg ',0
[解决办法]
insert into department select 1, 'Hardy ', 'Bob ',3
union select 2, 'Wallace ', 'Greg ',3
union select 3, 'Green ', 'Bob ',2
union select 4, 'Marsh ', 'Andy ',2
union select 5, 'Brown ', 'Greg ',0
