SQLite快速入门

# Syntax
$ sqlite3 DatabaseName.db

# Example
$ sqlite3 worker.db
# 查数据库
> .database
main: E:\githubProject\Work\worker.db
# 退出数据库
> .quit

# 巧用 < > 定向符进行导入导出
$ sqlite3 worker.db .dump > testDB.sql
$ sqlite3 worker.db < testDB.sql

/** 创建表**/
CREATE TABLE record(
  rid INT PRIMARY KEY  NOT NULL,
  uid            INT   NOT NULL,
  starttime      TIMESTAMP  NOT NULL,
  endtime        TIMESTAMP  NOT NULL,
  applytime      TIMESTAMP  NOT NULL,
  context        CHAR(255)  NOT NULL,
  daytype        CHAR(32)   NOT NULL,
  recordtime     TIMESTAMP  NOT NULL
);

CREATE TABLE user(
  uid INT PRIMARY KEY         NOT NULL,
  name           VARCHAR(32)  NOT NULL,
  gender         INT2         NOT NULL,
  yearsofwork    INT,
  address        VARCHAR(255)
);

CREATE TABLE recordtype (
  rid INT PRIMARY KEY    NOT NULL,
  name           TEXT    NOT NULL
);


insert into main.recordtype values (1,'加班申请'),(2,'请假申请'),(3,'年假申请'),(4,'病假申请'),(5,'其它申请');


INSERT INTO main.user VALUES (1,'张华',0,	null,715),
(11,'李浩',0,0,715);

/** 表中字符添加与修改 **/
alter table record add column daytype CHAR(32) NOT NULL;