Ubuntu 下安装sqlite3 及常用SQL 语句

1 sudo apt-get install sqlite3

1 sqlite3 test.db

CREATE TABLE ONT_USER_TABLE(
    ONT_USER_NAME text PRIMARY KEY,
    ONT_USER_PWD  text NOT NULL,
    ONT_CREATE_TIME text
);

INSERT INTO ONT_USER_TABLE values(‘admin‘,‘123456‘,‘2014-09-26 19:25‘);

UPDATE ONT_USER_TABLE SET ONT_USER_PWD = ‘abcdefg‘;

DELETE FROM ONT_USER_TABLE WHERE ONT_USER_NAME = ‘admin‘;

.schema

.table

.quit