如何实现一条sql语句插入多行数据

如何实现一条sql语句插入多行数据，用insert语句，请高手指教，谢谢~~

---

2种方做备雹并案纯肆毁
1)
insert into tab1(fld1, fld2....fldn)
SELECT field1, field2....fieldn fom tab2 where xxxxx

2) insert into tab1(fld1, fld2....fldn) VALUES(1, 11, ....1111), (2, 22, ..., 2222), .....,(n, nn,...., nnnn)

---

insert into tb (a,b,c,d)
select * from tbx where a<10

如果都是值也可乱判以
insert into tb(a,b,c)
select 'a'帆丛,'b','c' union
select 'd','态陪樱e','f' union
select 'x','y','z'

上面是三行数据

---

insert into table_A
select * from table_B
注意纯没冲：做歼表a,b栏位察亏数量和值类型要对应

---