創(chuàng)建數(shù)據(jù)庫

$sqlite3 DatabaseName.db

創(chuàng)建表

CREATE TABLE database_name.table_name(
   column1 datatype  PRIMARY KEY(one or more columns),
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
);

插入數(shù)據(jù)

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]  
VALUES (value1, value2, value3,...valueN);

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);

查詢數(shù)據(jù)

SELECT column1, column2, columnN FROM table_name;

更新數(shù)據(jù)

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

刪除數(shù)據(jù)

DELETE FROM table_name
WHERE [condition];