作者:剛強是什麼 | 来源:互联网 | 2023-06-30 18:39
svn:请使用“svnhelp”以得到更多信息[root@jikesvn]#sqlite3SQLiteversion3.6.20Enter“.help”forinstruction
svn: 请使用 “svn help” 以得到更多信息
[root@jike svn]# sqlite3
SQLite version 3.6.20
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite>
sqlite> create table stutable(sid,sname,sage);
sqlite> insert into stutable(sid,sname,sage)values(1,”jack”,”23″);
sqlite> insert into stutable(sid,sname,sage)values(2,”rose”,”21″);
sqlite> select * from stutable;
1|jack|23
2|rose|21
sqlite> update stutable set sname=”answer” where sid =1;
sqlite> select * from stutable;
1|answer|23
2|rose|21
sqlite> .mode columm
Error: mode should be one of: column csv html insert line list tabs tcl
sqlite> .mode column
sqlite> select * from stutable;
1 answer 23
2 rose 21
sqlite> .mode insert
sqlite> select * from stutable;
INSERT INTO table VALUES(1,’answer’,’23’);
INSERT INTO table VALUES(2,’rose’,’21’);
sqlite> .mode line
sqlite> select * from stutable;
sid = 1
sname = answer
sage = 23
sid = 2
sname = rose
sage = 21
sqlite> .separator “&&&”
sqlite> select * from stutable;
sid = 1
sname = answer
sage = 23
sid = 2
sname = rose
sage = 21
sqlite> .datebases
Error: unknown command or invalid arguments: “datebases”. Enter “.help” for help
sqlite> .databases
seq name file
— ————— ———————————————————-
0 main
sqlite> .tables
stutable
sqlite> .show
echo: off
explain: off
headers: off
mode: line
nullvalue: “”
output: stdout
separator: “&&&”
width:
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE stutable(sid,sname,sage);
INSERT INTO “stutable” VALUES(1,’answer’,’23’);
INSERT INTO “stutable” VALUES(2,’rose’,’21’);
COMMIT;
sqlite> .output file
sqlite> .exit
[root@jike svn]#