复杂写法可以留言，JavaPub

SQL:

select * from user where (user_id,type) in ((568,6),(569,6),(600,8));

MyBatis XML:

 select date_format(create_Time,'%Y-%m-%d %H:%i:%s') as createTime ,reason,operator,remarks,operation from refund_order_log
        where (order_no,channel) in
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            (#{item.orderNo},#{item.channel})
        </foreach>
        and status =1 order by create_time  desc

我是 JavaPub，三观很正，乐于创业，喜欢烹饪。今年已近年中，各位小伙伴一定已经拿到自己心仪的offer，但是不要忘记进步，共勉！