sql insert

1、标准Insert --单表单行插入
语法：

INSERT INTO table [(column1,column2,...)] VALUE (value1,value2,...)

例子:

insert into student(id,name,address) value(1,'xxx','xxx');

2、无条件 Insert all --多表多行插入
语法:

INSERT [ALL] [condition_insert_clause][insert_into_clause values_clause] (subquery)

示例:

INSERT ALL 
INTO sal_history(emp_id,hire_date,salary) values (empid,hiredate,sal)
INTO mgr_history(emp_id,manager_id,salary) values (empid,hiredate,sal)

3、查询结果插入新表

INSERT INTO 
router(id,title,icon,parent_id,types,path,seq,component)
SELECT A.id,A.`name`,A.icon,A.parent_id,A.types,A.link,A.seq,A.vue
FROM menu A

4、有条件的Insert
语法:

INSERT [ALL | FIRST]
WHEN condition THEN insert_into_clause values_clause
[WHEN condition THEN] [insert_into_clause values_clause]
......
[ELSE] [insert_into_clause values_clause] 
Subquery；

示例:

Insert All
when id>5 then into z_test1(id, name) values(id,name)
when id<>2 then into z_test2(id) values(id)
else into z_test3 values(name)
select id,name from z_test;