修改my.cnf配置文件
bulk_insert_buffer_size=120M
Max_allowed_packet=1M
Net_buffer_length=8k
批量入库 INSERT INTO M_Signal (Signal_Id, Signal_Name) VALUES(,'smkoe'),(,'water');
批量更新
INSERT INTO M_Signal (Id, Signal_Id, Signal_Name)
VALUES(, , 'smkoe'),(, , 'water')
ON DUPLICATE KEY UPDATE Signal_Id=values(Signal_Id),Signal_Name=values(Signal_Name);