-- 多字段批量更新
update table_name set field_name='hello world' where (field_1,field_2)in(('xxxxxxx','xxxxxxx'))
--多字段批量查询
select * from table_name where (field_1,field_2)in(('xxxxxxx','xxxxxxxx'))
-- 多字段批量更新
update table_name set field_name='hello world' where (field_1,field_2)in(('xxxxxxx','xxxxxxx'))
--多字段批量查询
select * from table_name where (field_1,field_2)in(('xxxxxxx','xxxxxxxx'))