update t_name set column1='xxx' where id not in(5,23,25,80) and id<=100
WHERE ID NOT IN(5,23,25,80)
update table set xx='' where id not in(5,23,25,80) and xx<100
where id<=100 and id not in(5,23,25,80)
要是在100至200间,但不包括115,123,125,180这4条记录,我主要是看怎样用between, update table set area='北京' where code not in (115,123,125,180) and (between 100 and 200) 这样不对,不知道咋写才对?
update xx set area='北京' where (code between 100 and 200) and (code not in (115,123,125,180) )
要是在100至200间,但不包括115,123,125,180这4条记录,我主要是看怎样用between, update table set area='北京' where code not in (115,123,125,180) and (between 100 and 200) 这样不对,不知道咋写才对?楼主的(between 100 and 200) 掉一CODE.
update table
set xx='' where id not in(5,23,25,80) and xx<100
update table
set area='北京'
where code not in (115,123,125,180) and (between 100 and 200)
这样不对,不知道咋写才对?
update xx
set area='北京'
where (code between 100 and 200) and (code not in (115,123,125,180) )
update table
set area='北京'
where code not in (115,123,125,180) and (between 100 and 200)
这样不对,不知道咋写才对?楼主的(between 100 and 200) 掉一CODE.