本文共 494 字,大约阅读时间需要 1 分钟。
delete gweb_operation_apply as a from gweb_operation_apply as a ,
(select *,min(apply_aiid) from gweb_operation_apply where apply_time >= date_add(curdate(),interval -1 day) group by user_id_number,user_moblie) bwhere a.apply_time >= date_add(curdate(),interval -1 day) and a.user_id_number = b.user_id_numberand a.apply_aiid > b.apply_aiid[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7916042/viewspace-1025281/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7916042/viewspace-1025281/