Mysql操作语句-插入语句

Mysql操作语句总结

数据库插入语句（多条数据插入）：

INSERT INTO table_name  (field1, field2,...fieldN)  VALUES  (valueA1,valueA2,...valueAN),(valueB1,valueB2,...valueBN),(valueC1,valueC2,...valueCN)......;

如下：

INSERT INTO t_usertype(userTypeID,userTypeName,userTypeNum) VALUES
(001,'a',20180113001),
(002,'b',20180113002),
(003,'c',20180113003);