SQL语句

• 修改

UPDATE <表名> SET <字段名=值> WHERE <筛选条件>;

update xlbh_pos set uid = 0 where snno between '00003002360390537021' and '00003002360390537070';

• 选择

select * from xlbh_pos where snno between '00003002360390536771' and '00003002360390536820';