where条件中有一种写法:
字段名 in (value1,value2,value3)
int 类型的字段,就按照上面的写法,string类型:
字段名 in (‘value1’,‘value2’,‘value3’)
update 表名 set status=1,quat=41 where ID between 11 and 15
UPDATE [表名] SET [Status] = 1, [quat] = 41 WHERE (ID >10 AND ID<15)
update tablename set status = 1,quat = 41 where id between 11 and 15