MySQL DML语句之INSERT

insert into 表名([字段名1，字段名2，字段名3]) values([值1，值2，值3])

INSERT INTO players(PASSWORD,NAME,getindate,district,email)VALUES('654321','芜香蛋','2016-06-23','中国','843110539@qq.com')
INSERT INTO players (PASSWORD,NAME,getindate,district,email) VALUES ('654321','芜香蛋','2016-06-23','中国','843110539@qq.com')

可以发现语法细节，即 表名后的空格可有可无，values 前后的空格可有可无

单次插入多条数据

INSERT INTO players(`password`,`name`,`getindate`,`district`,`email`)VALUES
('654321','芜香蛋','2016-06-23','中国','843110539@qq.com'),
('654321','芜香蛋','2016-06-23','中国','843110539@qq.com'),
('654321','芜香蛋','2016-06-23','中国','843110539@qq.com')