最快的插入方式,如果不存在,则在MySQL中获取id

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

SELECT LAST_INSERT_ID();

SELECT MAX(id) + 1 INTO @new_id FROM table_name;

INSERT INTO table_name (id, column1, column2, ...)
VALUES (@new_id, value1, value2, ...);

INSERT INTO table_name (id, column1, column2, ...)
VALUES (id_value, value1, value2, ...)
ON DUPLICATE KEY UPDATE
column1 = VALUES(column1),
column2 = VALUES(column2),
...;