DELETE FROM mt_click WHERE click_time < xxxxxx AND camp_id = yyy;
这个后面 AND camp_id = yyy;是指定campaign的id是吧
如果要删除所有campaign数据,这样DELETE FROM mt_click WHERE click_time < xxxxxx; 对吧
详情回复
发表于 2017-6-10 17:12
+ j k& ~, a, i0 V1 m# n
DELETE FROM mt_click WHERE click_time < xxxxxx AND camp_id = yyy; * E s) b3 O- O这个后面 AND camp_id = yyy;是指定campaign的id是吧) }) P- C: @5 _8 I; ^( e3 L. [8 v
如果要删除所有campaign数据,这样DELETE FROM mt_click WHERE click_time < xxxxxx; 对吧