这是我的HQL:
Query query = createQueryOnCurrentSession("DELETE Email e " + "where " + "(status = :sent and creationTime <= :creation)" + "or " + "(status = :error and maxEttempts >= :maxEttempts)");
delete from `email` where `status`=? and `creation_time`<=? or `status`=? and `attempts`>=?
问题:为什么括号不在sql中?
我希望它是:
delete from `email` where (`status`=? and `creation_time`<=?) or (`status`=? and `attempts`>=?)
也许我会在2个请求中删除?
delete from `email` where `status`=? and `creation_time`<=? delete from `email` where `status`=? and `attempts`>=?