Sql代码
- SELECT max(a) FROM zanbao.new_table;
- CREATE TABLE `new_table2` (
- `HD` varchar(8) NOT NULL COMMENT '设备ID',
- `VER` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
- PRIMARY KEY (`HD`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- 000001da 000001dB
- select * from zanbao.new_table2;
- select max(HD) from zanbao.new_table2; -- '000001dB'
- select max(VER) from zanbao.new_table2; -- '000001da'
Sql代码
- select * from zanbao.zb_dev_info_moni where hd= '0850002I' order by UDATE8035 ;
- select * from zanbao.zb_dev_info_moni where hd= '0850002I' order by UDATE9;
- select UD from lfchat.lf_usr_info t where t.TEL = '17876992101' and ('000001da'<'000001dB'); -- 000008
- select * from zanbao.zb_dev_usr_rel t where t.hd ='0850002I' and t.ver = '000001da'; -- 000001dB
- select ai from zanbao.zb_dev_usr_rel;
- select distinct(ud) from zanbao.zb_dev_usr_rel t where t.hd ='0850002I' ;
- select max(ver) from zanbao.zb_dev_usr_rel t where t.hd ='0850002I'; -- 000001dB
- select max(ver) from zanbao.zb_dev_info t where t.hd ='0850002I';
- update zb_dev_usr_rel set nc ='[{\"S_NT_3\":\"S_NT_3\",\"N_A\":\"赞宝专用--开机铃声\",\"S_NT_4\":\"S_NT_4\",\"S_NT_6\":\"S_NT_6\",\"S_BTN_A\":\"S_BTN_A\",\"N_E\":\"赞宝专用——无网络信号铃声\",\"N_N\":\"赞宝专用——未连接网络铃声\",\"N_B\":\"赞宝专用--关机铃声\",\"ST\":\"ST\",\"S_BTN_C\":\"S_BTN_C\",\"N_C\":\"赞宝专用——无网络配置铃声\",\"S_NT_7\":\"S_NT_7\",\"SD\":\"SD\",\"N_H\":\"赞宝专用——连接网络超时铃声\",\"N_J\":\"赞宝专用——登录成功铃声\",\"N_G\":\"赞宝专用——连接网络失败铃声2\",\"S_NT_5\":\"S_NT_5\",\"S_NT_8\":\"S_NT_8\",\"N_I\":\"赞宝专用——登录失败铃声\",\"N_L\":\"赞宝专用——按键发送失败铃声\",\"S_BTN_B\":\"S_BTN_B\",\"N_F\":\"赞宝专用——连接网络失败铃声\",\"S_NT_1\":\"S_NT_1\",\"N_D\":\"赞宝专用——网络连接铃声\",\"S_NT_2\":\"S_NT_2\"}]' where hd ='0850002I';
- SELECT * FROM zanbao.zb_dev_info t where t.hd ='0850002I';
- update zanbao.zb_dev_info set nc ='[{\"S_NT_3\":\"S_NT_3\",\"N_A\":\"赞宝专用--开机铃声\",\"S_NT_4\":\"S_NT_4\",\"S_NT_6\":\"S_NT_6\",\"S_BTN_A\":\"S_BTN_A\",\"N_E\":\"赞宝专用——无网络信号铃声\",\"N_N\":\"赞宝专用——未连接网络铃声\",\"N_B\":\"赞宝专用--关机铃声\",\"ST\":\"ST\",\"S_BTN_C\":\"S_BTN_C\",\"N_C\":\"赞宝专用——无网络配置铃声\",\"S_NT_7\":\"S_NT_7\",\"SD\":\"SD\",\"N_H\":\"赞宝专用——连接网络超时铃声\",\"N_J\":\"赞宝专用——登录成功铃声\",\"N_G\":\"赞宝专用——连接网络失败铃声2\",\"S_NT_5\":\"S_NT_5\",\"S_NT_8\":\"S_NT_8\",\"N_I\":\"赞宝专用——登录失败铃声\",\"N_L\":\"赞宝专用——按键发送失败铃声\",\"S_BTN_B\":\"S_BTN_B\",\"N_F\":\"赞宝专用——连接网络失败铃声\",\"S_NT_1\":\"S_NT_1\",\"N_D\":\"赞宝专用——网络连接铃声\",\"S_NT_2\":\"S_NT_2\"}]' where hd ='0850002I';
