数据 筛选:
查找 TacticsBean 表中 是否有包含 “mcd” 字样的 SSID 且 isV字段等N
关键字:
like 为包含(模糊查询) (查询 关键字 放于 %Y% 之间意为不区分大小写)
and 且
描述:
SELECT SSID FROM TacticsBean where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a,(SELECT SSID FROM TacticsBean) b WHERE a.ssid like '%'||b.SSID||'%') and isV = 'N'
SELECT SSID FROM TacticsBean // 查询来源于 表 TacticsBean
where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a WHERE a.ssid like '%'||b.SSID||'%') // where SSID = (条件)
and isV = 'N' //并且 isV 字段 值为 N
查找 字段 version ,要查找的表为WifiVersion
SELECT version FROM WifiVersion
//
数据 更新:
修改 TacticsBean 表中 SSID字段包含 “mcd” 字样的 isV字段值为Y
关键字:
update 更新
描述:
update TacticsBean set isV = 'Y' where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a,(SELECT SSID FROM TacticsBean) b WHERE a.ssid like '%'||b.SSID||'%')
/
修改 表名
alter table WifiVersion rename to Version
wifi_tool 添加一条数据
查找 TacticsBean 表中 是否有包含 “mcd” 字样的 SSID 且 isV字段等N
关键字:
like 为包含(模糊查询) (查询 关键字 放于 %Y% 之间意为不区分大小写)
and 且
描述:
SELECT SSID FROM TacticsBean where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a,(SELECT SSID FROM TacticsBean) b WHERE a.ssid like '%'||b.SSID||'%') and isV = 'N'
SELECT SSID FROM TacticsBean // 查询来源于 表 TacticsBean
where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a WHERE a.ssid like '%'||b.SSID||'%') // where SSID = (条件)
and isV = 'N' //并且 isV 字段 值为 N
查找 字段 version ,要查找的表为WifiVersion
SELECT version FROM WifiVersion
//
数据 更新:
修改 TacticsBean 表中 SSID字段包含 “mcd” 字样的 isV字段值为Y
关键字:
update 更新
描述:
update TacticsBean set isV = 'Y' where SSID =(SELECT b.ssid FROM (SELECT 'mcd' SSID) a,(SELECT SSID FROM TacticsBean) b WHERE a.ssid like '%'||b.SSID||'%')
/
修改 表名
alter table WifiVersion rename to Version
wifi_tool 添加一条数据
insert into TacticsBean (ssid) VALUES ('xxxxx');