SQL:
DELETE FROM TABLE_NAME
WHERE (COLUMNS_1,COLUMNS_2,COLUMNS_3) IN ((1,2,3),(1,2,3))
MYBATIS:
DELETE FROM TABLE_NAME
WHERE (COLUMNS_1,COLUMNS_2,COLUMNS_3) IN (
(#{item.columns1},#{item.columns2},#{item.columns3})
)
SQL:
DELETE FROM TABLE_NAME
WHERE (COLUMNS_1,COLUMNS_2,COLUMNS_3) IN ((1,2,3),(1,2,3))
MYBATIS:
DELETE FROM TABLE_NAME
WHERE (COLUMNS_1,COLUMNS_2,COLUMNS_3) IN (
(#{item.columns1},#{item.columns2},#{item.columns3})
)