DML 数据操作语言 INSERT

＃DML-Insert
Insert 是给现有表中插入新行，俗称添加数据
１．一次添加一条数据
INSERT INTO tbl_name (col1,col2,…) VALUES(val1,vals…);
INSERT INTO t1(id,name) values(4,‘test4’);

２．一次条件多条数据
INSERT INTO tbl_name (col1,col2,…) VALUES(val1,val2…),(val11,val12…),…;

INSERT INTO t1(id,name) values(5,‘test5’),(6,‘test6’);

3，按照查询后的结果添加
INSERT INTO table_name(col1,clo2,…)
SELECT col1,col2,…
FROM table_name WHERE condiation;

INSERT INTO t1(id,name)
SELECT max(id)+1001,‘insert select’
FROM t1 WHERE 1 =1;

4.INSERT … ON DUPLICATE KEY UPDATE Statement（暂不涉及）