SQL BASIS

CREATE DATABASE

Examples

$ sqlite3 student.db
		    

sqlite> .open student.db
		    

导出数据库

$sqlite3 student.db .dump > student.sql
		    

$sqlite3 student.db < student.sql
		    

查看表

sqlite> .tables
		    

查看表结构

sqlite> .schema student
		    

常用约束

1. NOT NULL
2. DEFAULT
3. UNIQUE
4. PRIMARY KEY
5. CHRCK