復制代碼 代碼如下:

insert into jobs(job_desc,min_lvl,max_lvl) values('SQL語句插入數據A',45,54)
insert into jobs(job_desc,min_lvl,max_lvl) values('SQL語句插入數據B',45,54)
insert into jobs(job_desc,min_lvl,max_lvl) values('SQL語句插入數據C',45,54)

復制代碼 代碼如下:

insert into jobs(job_desc,min_lvl,max_lvl)
select 'SQL語句插入數據A',45,54
union all select 'SQL語句插入數據B',45,54
union all select 'SQL語句插入數據C',45,54