安装

window http://www.sqlite.org/download.html

linux mac 自带

命令行

语法

SELECT FROM WHERE

Schema

create schema myschema;
create table myschema.company(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25),
   SALARY   DECIMAL (18, 2),
   PRIMARY KEY (ID)
);

select * from myschema.company;

DROP SCHEMA myschema;  # 删除一个为空的模式（其中的所有对象已经被删除）
DROP SCHEMA myschema CASCADE;  # 删除一个模式以及其中包含的所有对象：

DATABASE

CREATE DATABASE test;
DROP DATABASE test;

ATTACH DATABASE 'testDB.db' As 'test';
DETACH DATABASE 'test';

TABLE

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

CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
or
CREATE VIRTUAL TABLE database_name.table_name USING fts3( );

ALTER TABLE table_name ADD COLUMN column_def...;
ALTER TABLE table_name RENAME TO new_table_name;
DROP TABLE database_name.table_name;  # 清空数据，清空结构
TRUNCATE TABLE  table_name; # 清空数据，保留结构

UPDATE

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

DELETE