mysql::批量入库

 

修改my.cnf配置文件
bulk_insert_buffer_size=120M 
Max_allowed_packet=1M
Net_buffer_length=8k

 

批量入库

INSERT INTO M_Signal (Signal_Id, Signal_Name) VALUES(12,'smkoe'),(13,'water')；

 

批量更新
INSERT INTO M_Signal (Id, Signal_Id, Signal_Name) 
VALUES(82854, 12, 'smkoe'),(82855, 13, 'water')
ON DUPLICATE KEY UPDATE Signal_Id=values(Signal_Id),Signal_Name=values(Signal_Name);