insert into table 插入多条数据

insert into table 插入多条数据
方法1：
insert into `ttt`
select '001','语文' union all
select '002','数学' union all
select '003','英语';


方法2：
INSERT INTO tab_comp VALUES(item1, price1, qty1),
(item2, price2, qty2),
(item3, price3, qty3);
--------------------------------------------------------------------


create table info_user(
    U_id     int(11)    not null  primary key   auto_increment,
    U_name   varchar(100)   not null


);


insert into info_user(U_name) values("张三"),("李四"),("王五");


mysql> insert into info_user(U_name) values("张三"),("李四"),("王五");
Query OK, 3 rows affected, 3 warnings (0.03 sec)
Records: 3  Duplicates: 0  Warnings: 3










方法3：
 INSERT INTO tab_comp(item1, price1, qty1) SELECT item1, price1, qty1 FROM tab_cc;