!(...)
: 这表示否定括号内的条件,即排除满足括号内条件的记录。
SELECT
id
FROM
`xxl_job_log`
WHERE
! ( ( trigger_code IN ( 0, 200 ) AND handle_code = 0 ) OR ( handle_code = 200 ) )
AND `alarm_status` = 0
ORDER BY
id ASC
LIMIT #{pagesize}
!(...)
: 这表示否定括号内的条件,即排除满足括号内条件的记录。
SELECT
id
FROM
`xxl_job_log`
WHERE
! ( ( trigger_code IN ( 0, 200 ) AND handle_code = 0 ) OR ( handle_code = 200 ) )
AND `alarm_status` = 0
ORDER BY
id ASC
LIMIT #{pagesize}