wget http://www.sqlite.org/sqlite-3.6.16.tar.gz
tar -zxvf sqlite-3.6.16.tar.gz
cd sqlite-3.6.16
./configure
make;make install
ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite
[root@inbelle ipsecmc]# sqlite
user.db
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
sqlite> .tables
p2pvpn_client
sqlite> select * from p2pvpn_client;
group001|test001|123456
group001|test002|123456
group001|test003|123456
group001|test004|123456
group001|test005|123456
group002|test001|123456
group002|test002|123456
group002|test003|123456
group002|test004|123456
group002|test005|123456
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
sqlite> .tables
p2pvpn_client
sqlite> select * from p2pvpn_client;
group001|test001|123456
group001|test002|123456
group001|test003|123456
group001|test004|123456
group001|test005|123456
group002|test001|123456
group002|test002|123456
group002|test003|123456
group002|test004|123456
group002|test005|123456
sqlite> .schema
CREATE TABLE p2pvpn_client(
groupname varchar(32) NULL,
username varchar(32) NULL,
password varchar(32) NULL);
CREATE TABLE p2pvpn_client(
groupname varchar(32) NULL,
username varchar(32) NULL,
password varchar(32) NULL);
sqlite> insert into "p2pvpn_client"
values ("group001","test006","123456");
sqlite> select * from p2pvpn_client;
group001|test001|123456
group001|test002|123456
group001|test003|123456
group001|test004|123456
group001|test005|123456
group002|test001|123456
group002|test002|123456
group002|test003|123456
group002|test004|123456
group002|test005|123456
group001|test006|123456
sqlite>
sqlite> .exit
sqlite> select * from p2pvpn_client;
group001|test001|123456
group001|test002|123456
group001|test003|123456
group001|test004|123456
group001|test005|123456
group002|test001|123456
group002|test002|123456
group002|test003|123456
group002|test004|123456
group002|test005|123456
group001|test006|123456
sqlite>
sqlite> .exit