mysql 插入语句

INSERT INTO activity_rank_logs (ranking, day, lender_id,username,money,rank_type,dt) VALUES

(1, '2018-03-15', 422580,'18998313897',133571349,2,'2018-03-15 00:00:00');

日期和用户名要加单引号,结尾已分号结尾

//多条语句插入

INSERT INTO activity_rank_logs (ranking,day,lender_id,username,money,rank_type,dt) VALUES
(1, '2018-03-15', 42250,'189313897',133571349,2,'2018-03-15 00:00:00'),
(2, '2018-03-15', 37743,'180805235',116489463,2,'2018-03-15 00:00:00'),
(3, '2018-03-15', 42328,'159130956',80167550,2,'2018-03-15 00:00:00'),
(4, '2018-03-15', 40624,'135111949',70355476,2,'2018-03-15 00:00:00'),
(5, '2018-03-15', 40594,'139715345',70015628,2,'2018-03-15 00:00:00');