SQLite 基础9
分离数据库
无法分离 main 和 temp 数据库
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /usr/local/sqlite3.11/bin/test.db
2 abc /usr/local/sqlite3.11/bin/test_tmp.db
sqlite> detach database main;
Error: cannot detach database main
sqlite> detach database abc;
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /usr/local/sqlite3.11/bin/test.db
sqlite> Tip: 可以使用 attach 的方法来创建数据库别名
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /usr/local/sqlite3.11/bin/test.db
sqlite> .tables
hello t2 test
sqlite> attach database 'test.db' as 'new';
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /usr/local/sqlite3.11/bin/test.db
1 temp
2 new /usr/local/sqlite3.11/bin/test.db
sqlite> .tables
hello new.hello new.t2 new.test t2 test
sqlite> select * from new.t2;
2|hello
4|hello
sqlite>
sqlite> detach database temp;
Error: cannot detach database temp
sqlite> detach database main;
Error: cannot detach database main
sqlite> 创建表
sqlite> .tables
hello t2 test
sqlite> create table ui(
...> id int,
...> name text,
...> age int);
sqlite> .schema ui
CREATE TABLE ui(
id int,
name text,
age int);
sqlite> .tables
hello t2 test ui
sqlite> 本文系转载，前往查看
如有侵权，请联系 cloudcommunity@tencent.com 删除。
本文系转载，前往查看
如有侵权，请联系 cloudcommunity@tencent.com 删除。
评论
登录后参与评论
推荐阅读
目录
腾讯云开发者
