MySQL:ON DUPLICATE KEY UPDATE用法避免重复插入数据

INSERT INTO osc_visit_stats(stat_date,type,id,view_count) VALUES ( , , , ) ON DUPLICATEKEY UPDATE view_count=view_count+ 

INSERT INTO osc_space_visit_records(space,user,visit_count,ip,visit_time) VALUES( , , , , ) 
ON DUPLICATE KEY UPDATE visit_count=visit_count+1,ip= ,visit_time=NOW()