数据库小计

 where RecNumber='31833631' order by LogTime desc

where查找

RecHumber='31833631'  键=‘键值’

order by 排序 根据....排序

order by LogTime 根据时间排序

desc  为降序  ace为升序

update HLSetting set IsSetting2 = 0 where SerialNumber ='31833631'

update更新修改

HLSetting 表名

IsSetting2 = 0 键=‘修改后的键值’

where SerialNumber ='31833631'  确实SerialNumber ='31833631'修改目标

select * from HLSetting  where SerialNumber ='31833631'

select查询

* 全部

form HLSetting  来自 表名

where SerialNumber='31833631' 为查找条件