SELECT插入记录以及批量元组新增，将查询的结果存到表中

1.插入记录

INSERT INTO table_name(id,name,phone,address) VALUES (1,"张三","11111111111","北京"), (2,"赵四","22222222222","天津"), (3,"王五","33333333333","河北");

2.将多条查询结果插入表中

INSERT INTO table_name(name,phone) SElECT name,phone FROM table2_name ORDER BY name;