类似oracle merge into
首选设置DUPLICATE KEY 联合主键
ALTER TABLE tb_acl_statistics ADD UNIQUE (aclid,trojan_name);
插入 语句后加入 ON DUPLICATE KEY 主键匹配成功后所要做的更新操作
INSERT IGNORE INTO tb_acl_statistics (aclid,trojan_name,num) VALUE(1,'test',80 ) ON DUPLICATE KEY UPDATE num =num+80;