yum install sqlite-devel

sqlite3 school.db

sqlite> .database
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /root/python_scripts/school.db

sqlite> create table student (
   ...> id integer primary key autoincrement,
   ...> name varchar(50) not null,
   ...> age int not null default 18
   ...> );

sqlite> .table
student

sqlite> insert into student (name,age) values
   ...> ('tom',20),
   ...> ('alice',16),
   ...> ('helen',20);

# 切换列显示
sqlite> .mode column

sqlite> select * from student;
1           tom         20        
2           alice       16        
3           helen       20

# 命令行 方式
sqlite> .output school.sql
sqlite> .dump


# shell 方式
sqlite3 school.db ".dump" > school.sql

sqlite> delete from student;

sqlite> drop table student;

# 命令行 方式
sqlite> .read school.sql


# shell 方式
sqlite3 school.db < school.sql