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' 为查找条件