minute(time);注意minute是小写
DELETE from hrrecruit_sap_info_temp WHERE id IN (SELECT a.id from (SELECT p.ID FROM `hrrecruit_sap_info_temp` p WHERE minute(now())-minute(p.SAVEDATE)>5)a);
minute(time);注意minute是小写
DELETE from hrrecruit_sap_info_temp WHERE id IN (SELECT a.id from (SELECT p.ID FROM `hrrecruit_sap_info_temp` p WHERE minute(now())-minute(p.SAVEDATE)>5)a);