sqlite 数据库 查询时显示表字段
bash-2.05b# lscert devm radius rule sqlite3uibase vpn
bash-2.05b# ./sqlite3 rule
//启动 进入数据库
SQLite version 3.5.4
Enter ".help" for instructions
sqlite> .tab
// 显示数据库中表
DomainName RuleIpFilterStatout RuleSnatIp
IpObj RuleIpFilterTime RuleSnatPro
sqlite> select * from IpObj;//查询表
1|test1|0|1|1.0.0.0||
2|test2|8|1|1.0.0.0||
sqlite> .h on
// 显示表字段命令
sqlite> select * from IpObj;
Id|Name|VsysId|Refcount|StartIp|EndIp|Mask
// 表字段
1|test1|0|1|1.0.0.0||
2|test2|8|1|1.0.0.0||
sqlite> insert into IpObj (Name,VsysId,Refcount,StartIp,EndIp,Mask) values('a','3','2','1.1.1.1','','');
//添加操作
sqlite> select * from IpObj;
Id|Name|VsysId|Refcount|StartIp|EndIp|Mask
1|test1|0|1|1.0.0.0||
2|test2|8|1|1.0.0.0||
3|a|3|2|1.1.1.1||
sqlite> update IpObj set Name='aaa' where Id=3;
//修改操作
sqlite> select * from IpObj;
Id|Name|VsysId|Refcount|StartIp|EndIp|Mask
1|test1|0|1|1.0.0.0||
2|test2|8|1|1.0.0.0||
3|aaa|3|2|1.1.1.1||
sqlite> delete from IpObj where Id=3;
// 删除操作
sqlite> select * from IpObj;
Id|Name|VsysId|Refcount|StartIp|EndIp|Mask
1|test1|0|1|1.0.0.0||
2|test2|8|1|1.0.0.0||
页:
[1]