Answers for "mysql insert syntax"

mysql insert on dupèlicate

INSERT INTO table_name(c1)
VALUES(c1)
ON DUPLICATE KEY UPDATE c1 = VALUES(c1) + 1;

insert mysql

INSERT INTO tbl_name (a,b,c) 
    VALUES(1,2,3), (4,5,6), (7,8,9);

insert into mysql

INSERT INTO "table_name" ("column1", "column2", "column3", ...)
VALUES ('value1', "value2", 'value3', ...);