MySql的upsert操作 INSERT INTO ods_qq_group_members ( gid, uin, datadate ) VALUES (111, 1111111, '2016-11-29' ) ON DUPLICATE KEY UPDATE gid=222, uin=22222, datadate='2016-11-29' 注:update后面没有小括号,后面是field=value的形式