改变表名 - ALTER TABLE 旧表名 RENAME TO 新表名 增加一列 - ALTER TABLE 表名 ADD COLUMN 列名 数据类型
SELECT name FROM sqlite_master where type='table' order by name;
sqlite3 test.db
命令进入sqlite数据库的shell 操作:1,导出数据库某个表:
# 先执行
.output table_name.sql
# 在执行
.dump table_name
如果是导出全部表:
直接 .dump
2,导入数据表:
.read table_name.sql
1,导出表:
cmd = "sqlite3 db.sqlite3 '.dump table_name' > table_name.sql"
os.system(cmd)
2,导入表:
cmd = "sqlite3 db.sqlite3 '.read table_name.sql' "
os.system(cmd)
执行“sqlite3.exe”,我们可能用到下面几个命令:
sqlite> .help
.dump ?TABLE? ... Dump the database in an SQL text format
If TABLE specified, only dump tables matching
LIKE pattern TABLE.
.exit Exit this program
.help Show this message
.open ?--new? ?FILE? Close existing database and reopen FILE
The --new starts with an empty file
.output ?FILENAME? Send output to FILENAME or stdout
.quit Exit this program
.read FILENAME Execute SQL in FILENAME
.tables ?TABLE? List names of tables
If TABLE specified, only list tables matching
LIKE pattern TABLE.
sqlite>
sqlite3 -csv -header vz3.db "select * from t_city_domestic_all_new" > city.csv
参考:https://blog.csdn.net/kevin_weijc/article/details/78920593 https://blog.csdn.net/u013600225/article/details/53898697 https://www.jianshu.com/p/2980342c7be6 https://blog.csdn.net/yujianxiang666/article/details/46724923