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);