sqlite> .open db1.

db
sqlite> .tables
images tbl1 tbl2 tbl3 tbl4
sqlite> .databases
main: E:\ramani\college-work\subjects\Python\sqlite-tools-win32-x86-3380500\db1.db r/w
sqlite> attach database 'db1.db'
...> ;
Parse error: near ";": syntax error
attach database 'db1.db' ;
error here ---^
sqlite> attach 'db1.db';
Parse error: near ";": syntax error
attach 'db1.db';
^--- error here
sqlite> attach databases 'db1.db'
...> ;
Parse error: near "'db1.db'": syntax error
attach databases 'db1.db' ;
^--- error here
sqlite> attach as 'db2.db'
...> ;
Parse error: near "as": syntax error
attach as 'db2.db' ;
^--- error here
sqlite> attach database as 'db2.db'
...> ;
Parse error: near "as": syntax error
attach database as 'db2.db' ;
^--- error here
sqlite> attach database 'E:\ramani\college-work\subjects\Python\sqlite-tools-win32-x86-3380500\
db2.db'
 ...> ;
Parse error: near ";": syntax error
cts\Python\sqlite-tools-win32-x86-3380500\db2.db' ;
error here ---^
sqlite> attach database E:\ramani\college-work\subjects\Python\sqlite-tools-win32-x86-3380500\
db2.db
...> ;
Parse error: unrecognized token: ":"
attach database E:\ramani\college-work\subjects\Python\sqlite-tools-win32-x86-
^--- error here
sqlite> attach database 'db4.db'
...> ;
Parse error: near ";": syntax error
attach database 'db4.db' ;
error here ---^
sqlite> attach database 'db4.db';
Parse error: near ";": syntax error
attach database 'db4.db';
^--- error here
sqlite> attach database 'db4.db' as db4;
sqlite> attach database 'db5.db';
Parse error: near ";": syntax error
attach database 'db5.db';
^--- error here
sqlite> attach database 'db5.db' as db5;
sqlite> .tables
images tbl1 tbl2 tbl3 tbl4
sqlite> .schema tabl1
sqlite> .schema tbl1
CREATE TABLE tbl1(one varchar(10), two smallint);
sqlite> .schema images
CREATE TABLE images(name TEXT, type TEXT, img BLOB);
sqlite> select * from tbl1;
aaa|123
bbb|111
sqlite> .mode list
sqlite> select * from tbl1;
aaa|123
bbb|111
sqlite> .mode table
sqlite> select * from tbl1;
+-----+-----+
| one | two |
+-----+-----+
| aaa | 123 |
| bbb | 111 |
+-----+-----+
sqlite> .mode box
sqlite> select * from tbl1;
┌─────┬─────┐
│ one │ two │
├─────┼─────┤
│ aaa │ 123 │
│ bbb │ 111 │
└─────┴─────┘
sqlite> .mode list
sqlite> select * from tbl1;
aaa|123
bbb|111
sqlite> .separator ,
sqlite> select * from tbl1;
aaa,123
bbb,111
sqlite> .separator #
sqlite> select * from tbl1;
aaa#123
bbb#111
sqlite> .header on
sqlite> .mode list
sqlite> select * from tbl1;
one|two
aaa|123
bbb|111
sqlite> .mode list
sqlite> .separator ,
sqlite> .header on
sqlite> select * from tbl1;
one,two
aaa,123
bbb,111
sqlite> .echo on
sqlite> select * from tbl1;
select * from tbl1;
one,two
aaa,123
bbb,111
sqlite> .echo off
.echo off
sqlite> select * from tbl1;
one,two
aaa,123
bbb,111
sqlite> .mode table
sqlite> select * from tbl1;
+-----+-----+
| one | two |
+-----+-----+
| aaa | 123 |
| bbb | 111 |
+-----+-----+
sqlite> .width 15
sqlite> .mode table
sqlite> select * from tbl1;
+-----------------+-----+
| one | two |
+-----------------+-----+
| aaa | 123 |
| bbb | 111 |
+-----------------+-----+
sqlite> .width 15 column 'two'
sqlite> .mode table
sqlite> select * from tbl1;
+-----------------+-----+
| one | two |
+-----------------+-----+
| aaa | 123 |
| bbb | 111 |
+-----------------+-----+
sqlite> .mode table
sqlite> .width 15,10
sqlite> select * from tbl1;
+-----------------+-----+
| one | two |
+-----------------+-----+
| aaa | 123 |
| bbb | 111 |
+-----------------+-----+
sqlite> .width 15, 20
sqlite> select * from tbl1;
+-----------------+----------------------+
| one | two |
+-----------------+----------------------+
| aaa | 123 |
| bbb | 111 |
+-----------------+----------------------+
sqlite> .width 15,10
sqlite> select * from tbl1;
+-----------------+-----+
| one | two |
+-----------------+-----+
| aaa | 123 |
| bbb | 111 |
+-----------------+-----+
sqlite> .width 15, 10
sqlite> select * from tbl1;
+-----------------+------------+
| one | two |
+-----------------+------------+
| aaa | 123 |
| bbb | 111 |
+-----------------+------------+
sqlite> .output off
sqlite> select * from tbl1;
+-----------------+------------+
| one | two |
+-----------------+------------+
| aaa | 123 |
| bbb | 111 |
+-----------------+------------+
sqlite> .output aaaa.txt
sqlite> select * from tbl1;
sqlite> select * from tbl1;
sqlite> .mode
sqlite> select * from tbl1;
sqlite> .output
sqlite> select * from tbl1;
+-----------------+------------+
| one | two |
+-----------------+------------+
| aaa | 123 |
| bbb | 111 |
+-----------------+------------+
sqlite> .mode
current output mode: table --wrap 60 --wordwrap off --noquote
sqlite> .quote '
Error: unknown command or invalid arguments: "quote". Enter ".help" for help
sqlite> .mode quote
sqlite> select * from tbl1;
'one','two'
'aaa',123
'bbb',111
sqlite> .mode column
sqlite> select * from tbl1;
one two
--------------- ----------
aaa 123
bbb 111
sqlite> .save mydatabase
sqlite> .save mydatabase.db
sqlite> .save mydatabase.txt
sqlite> insert into tbl1 values('this is a python book', 222);
sqlite> select * from tbl1;
one two
--------------- ----------
aaa 123

bbb 111

this is a pytho 222

n book
sqlite> .mode table
sqlite> select * from tbl1;
+-----------------+------------+
| one | two |
+-----------------+------------+
| aaa | 123 |
+-----------------+------------+
| bbb | 111 |
+-----------------+------------+
| this is a pytho | 222 |
| n book | |
+-----------------+------------+
sqlite> .width 10, 5
sqlite> select * from tbl1;
+------------+-------+
| one | two |
+------------+-------+
| aaa | 123 |
+------------+-------+
| bbb | 111 |
+------------+-------+
| this is a | 222 |
| python boo | |
|k | |
+------------+-------+
sqlite> .width 10, 5 --ww 10
sqlite> select * from tbl1;
+------------+-------+
| one | two |
+------------+-------+
| aaa | 123 |
+------------+-------+
| bbb | 111 |
+------------+-------+
| this is a | 222 |
| python boo | |
|k | |
+------------+-------+
sqlite> .width 10, 5 --ww 15
sqlite> select * from tbl1;
+------------+-------+
| one | two |
+------------+-------+
| aaa | 123 |
+------------+-------+
| bbb | 111 |
+------------+-------+
| this is a | 222 |
| python boo | |
|k | |
+------------+-------+
sqlite> .mode list
sqlite> .wrap 15
Error: unknown command or invalid arguments: "wrap". Enter ".help" for help
sqlite> .mode list
sqlite> select * from tbl1;
one|two
aaa|123
bbb|111
this is a python book|222
sqlite> .mode list --ww 10
sqlite> select * from tbl1;
one|two
aaa|123
bbb|111
this is a python book|222
sqlite> .once -x
sqlite> select * from tbl1;
sqlite> .read mysqlfile.sql
sqlite> .output
sqlite> .read mysqlfile.sql
Parse error near line 1: table emp already exists
create table emp(no integer, name varchar2(10));
^--- error here
sqlite> .read mysqlfile.sql
sqlite> .tables
emp emp1 images tbl1 tbl2 tbl3 tbl4
sqlite>