1、无条件insert all 语法示例(将查询出的数据全部插入到指定的表格中):insert allinto emp_name(emp_id,lastname,firstname) values (employeeid,lastname,firstname)into emp_addr(emp_id,address)values (employeeid,address)select employeeid,lastname,firstname,addressfrom employees w