sqlite 数据库 查询时显示表字段

yupianer

bash-2.05b# lscert     devm     radius   rule     sqlite3  uibase   vpnbash-2.05b# ./sqlite3 rule //启动 进入数据库SQLite version 3.5.4Enter ".help" for instructionssqlite> .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|Mask1|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|Mask1|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|Mask1|test1|0|1|1.0.0.0||2|test2|8|1|1.0.0.0||