!This program cannot be run in DOS mode.
`.rdata
@.data
@.reloc
C{H\Sc\
xiLHU2
8sr$gr
F%pPui
<S4R&1z
b'x dr
a%8xU)hyf
7Hn& h
ZK*9e3"
l?P rR
/9yJ9{
RWQ2g/\k
BZ_O[j
]Q0bA;
I%~yBE{9
K1 n `
B^jhYX
o,0`5\
I=B5gB
Yv Zu|h
`sxoyZ`
]6=uSm
6+&~%j6
<!GnyR,
\QWgeJ
#CSy>oR
Xh`ujL
|U(Mfz
@BnVjj
+.S9Jw?
m>xtyF;
D 6z7W
GKpAEK\
%1*XRoN
V)zT~!
wu;:D|KT#
ONFwWO8
jWiq&[
7%oI
<S4R&1zK;
>`$Lv%
=KPe}>
NCm$!g
R9p?)>
)j'@aR
sNc#u0j
&~oStZZ
zXIi-I?_@
l.v D?
=T|GyD
Zv=d3!A
<!GnyR,
B\)Vs//
1rEa7(
\QWgeJ
7l fdR
y>oRul
#p#i!J
NLL[Fw
%1*XRoN
T>fDj?o
0IX$t$
Xh`ujL
M7k~QKe
rRwn/{`
]Q0bA;
^LO@0m
go]g=Uf
B^jhYX
r:1Y(F
SW ZdI
I=B5gB'-
Fp=Q^(M
+-b>CP
EZ\y8}#
1"gu|N
>F!3 @
M[,}-s
KHFq]]~
px97S<
#.V(-}
^04Q)$/
C)kv|=9
@]0&)<
a\SQoE
9Eu%X!
*83In_
@doU\p
"o<1oh^
K"K0K9b
8r:wG'v
(f5|!F
wTNoaX}H
of18tm
zGdYQav
<`c3vA
)_uV+B
X3^82)
^r7kE)9
X3^82)
CA?_j!?
z,FGoH
)_uV4m|
z1; ?Y
9Euc:_
}yM*L?
-m?<i c?
WgwnC
^bOWYC
c<WZh2
$p=YzF
$};K@S
[s#@NTf
?;=sxz
#60? A
/jP15:
_/NJo~
gf:+8.u
5<F;6)
^vt|b.&Q
s=9{^f
T.<=LU
N%bl+7-
kWz36\0
Gg>j!/
t*p2PuP$
S4aPU<~Y
v=7;Zi4\T
GF9z&*VJ
H+z]cTDs
#rU_L=
eppjYAo
7Lzse5
w)1;E%
iF]}Mn
EG6qJ-
lyUPKb_\
S1^f~D
K~tr`8
EG6qJ-
K~tr`8
h}~S>q
3EchzG
=|}8va|U
K()B&@
]ScL~4
q^DmCq
KJLwS*
1;'w?$
+c3v5=x
Sn(Q,&
+*@)qz
{<*N(M
[;\=9~
?#8eEf
_f^p?%
y'wE(>
R.4(c@-
xUY|f;
\F.uE3
CxO&1S
m/EE$'w
[bg1-N
;P?6]A2
c)=-S
LyV u8(
e'pL*+
(PG(m`
7"iCfZ
I\bV-!
F:X>9#
1c:*14
dcTAIG
Z(!OUV
]md_Z4
YJ8&%]$p
&Q//*7
n{jv3Py1%(
qHB=>2
\T_Ey
}do1,]
2fFm q
Ba{F`6u
Q[oJT5
WOmPBI
zCWK,k
R Ik/>z
viY|ob$[
!}bV]{
=/BQEg
`tq2sTkY
S)luU$^{
m7~NIF
f+fC%#
r S+lW
`R1h_y
TU1?uu
1k>pTc
Me92zV(
qJg.'*
OS5@`L
2[5/xxv
OKY5>g
T+fYqh=r
w(0}P9
YW}weT%
b1Aj~[}
WYaED,|.32
hY^'5F
,+z4.7
E;q6mj
t_ti*!
Y)oQ,r
hdbSJOc
z$6$jb.
<, Eoik
dZ%S'
so'cOP
I 1iTao
Dmf3in
@_hTNmF/b
(0Cb8G
`h);%fR
3hG uL
e61/_)H
knh9T)/R
x*rZN)
CV2aCb
zVH+q]
[E0$1M
sf'_x]
u9)uh&
cmwV}&
{^'3W%
1&N\Ad
y U3e:
{>:w]}
O.&&!p
ML~7,i*
Ql_aZ^
Y\&T?W
tK9\$Hu5
<>_u/F
PSQVhP
PSQVh`
3A,3AT3A|3
3A43A\3
3Q(3QP3Qx3
3A<3Ad3
3Q03QX3
3A@3Ah3
q$3qL3qt
3Q83Q`3
3YD3Yl3
3A,3AT3A|3
3Q(3QP3Qx3
3A43A\3
3Q03QX3
3A<3Ad3
3Q83Q`3
3A@3Ah
y 3yH3yp
3AT3A|3
3QP3Qx3
3A43A\3
3A<3Ad3
3Q03QX3
3A@3Ah3
q$3qL3qt
3Q83Q`3
3YD3yp3Yl3
3A,3AT3A|3
3A43A\3
3Q(3QP3Qx3
3Q03QX3
3A<3Ad3
3Q83Q`3
3A@3Ah3
L$<+L$
L$D+L$
L$L+L$
L$d_^[3
L$$^[3
L$<SSj
u395<i`
u39=<i`
D$8Pjd
8-t'Ph
PVSVWh
PPPPPh
9|$4uM
9T$$us
t?j[h0
D$PPQh
D$ <(t
L$(j[h0
uP9OLtK
us9OLtnh
uv9OLtq3
u`9OLt[
D$8;D$@}
ux9OLts3
L$l_^[3
D$pSVW
L$|_^[3
D$`PQh
D$@9D$
D$@9D$
D$<9D$
D$4;L$L
9L$4u$
D$4;L$L
L$8^[3
uQ9GHu
QSVWh,
D$,CPW
D$@FPW
L$T_^[3
PPPPPh
ukPPPPPh
ukPPPPPh
uFPPPPPh
u!PPPPPh
PWhT5Y
W`_^Y]
w`_^Y]
\$4hp6Y
t<hDkY
PWhT5Y
#uX<-t
D$$P@Y
t"hpAY
t$thDZY
uQVhtZY
~$hd\Y
9D$@}4
t$,Vh0IY
D$4PQV
8|u$@h
t"h\OY
VSh|PY
D$LPVW
bu1Ph
<nuRVh
CVh0TY
HVh8TY
PVh\UY
WVhtUY
<qu'Vh
8|ur@h
u?h,cY
9D$4}-
t$,h`cY
vYVh(dY
phhDfY
;D$ |&
uuh|fY
tRh|hY
PWhT5Y
\$$8^[u
FPh@iY
D$0PhDiY
L$ +L$`
u@8FSu;8FTu6
D$|SPQRVO
t>@:T$L
t$@9t$ t
D$d:L$Lu
L$l_^3
L$l_^3
WWh@wY
r8;N8u
;V<t.9^$u)
V<9^4|
9~L~)ff
9t$(u_
D$0Ph,yY
t5h\HY
</tA<\t=
D$ SVW
s.;N s)
9V`~$3
[0;~`|
W9S`~,3
t@8K+t3
u&9GXt!
B ;ADs
;C4s j
Fh;^ v
F;s`}#
L$$_^[3
L$4_^[3
\$(;D$0u
u~8^+u
u 8F+u
tL8^+uG
t*9NPt
;x0v(h
|z9X4tu
t39xPt
T$,;D$
D$ ;X0
@<+A(;
\$<u,;
t$4;t$8
D$ ;G0v(h
;w<v*h
T$$;D$,
F4;H(v+h
\$0+H8
T$$+A8
|$89L$4
\$,;t$8
+T$PBf
\$P9t$
T$TF;t$
G;|$ }4
8;L$4}
L$8+L<x
9\$4~e
C;\$4|
9\$ ~h
C;\$ |
L$,_^[3
;F$u,f
;G<v4h
|$ 9ppuR
D$$;x,s
;H<v5h
L$L_^[3
9D$(r%
L$L_^[3
;{0v*h
;W0v5h
L$<_^[3
;S0v5h
L$$_^[3
L$,_^[3
D$PVW3
tbPhp{Y
r PQh |Y
;|$0tfh8|Y
\$LWPhT|Y
WPRh||Y
D$0@_^[
tFhx}Y
L$P^[3
L$H;|$@
u+<Au'
D$0SVW
9t$$t2
9D$8t7
u 9^(t
GD#F(_^[
;t$,v:h
\$0;\$4
L$`^[3
:xC+\$
PPt+8S
L$4_^[3
gfff+Nh
w0;AXu+
f9BBvi
D$48F[u
\$(9Vp
D$8+D$4PQ
L$\_^3
L$4_^[3
|$$9yH
WD_^[Y]
WD_^[Y]
L$8r&P
D$HVSPQ
D$8_^[
D$8_^[
D$8_^[
;Ax~%h
u,9;~&
u69CDt%
D$(;D$
L$T_^[3
D$<_^[
T$(9Wp
t$0t|f
L$T_^[3
t$D9L$
D$,;D$
T$ 9Vp
T$ ;L$,us;
;D$,uQ
L$L9Np
D$T9Np
D$09Vp
NlB9Np
L$\_^[3
D$ SVW
L$,_^[3
G f;F
A f;F t
PQRPRQh
f;G*}H3
L$L_^3
f;F*}73
t$L9D$
u&9_tu
u(9wtu
u!f9_2u
|$49Np
A,@PWV
|$ Wh\
@M:FPt
u98^[u
L$4_^[3
L$\_^3
D$ 9q`~&
GP#D$,
D$(9Vp
t$ ;0|
u 8GSu
L$|_^3
f;H*}8
C$ tjf
G*@;Bx~
L$l_^[3
uI8GSu;8GTu6
T$$u.3
f;F2sDWV
D$ 9D$
D$ ;D$
f;D$(sk
T$$C;\$
f;H*}`
u&9Ktu
D$(@Pj
D$(9Jp
L$d_^[3
f!HN_^[
u"9wtu
u"9~tu
u&9wtu
\$89G$
u"9_tu
ux9N8us
D$H@Pj
D$,+D$
f;C*}F
;wl}1f
L$4_^[3
;L$,|3
9D$ v+
L$$_^[3
L$|_^[3
G _^[]
T$$9Vp
D$,9Np
D$,9Vp
L$,9Np
uh9Ctuc8C
xMf;V(tG
T$09Wp
f;x2s|
L$\_^[3
L$$F;w
t*;G u
L$D_^[3
9T$4t-
f;N4sS3
f;O*}%3
f;G*}*3
D$L@Pj
F*+D$P;
D$$9T$P~-
|$@;|$H
L$,HAPQ
u-8L$du'
D$H9Np
f#D$tf
u%9Atu
T$\9Np
;L$Dtl
tn9D$xth
L$xt1;
|$0tA;
|$4f;H2
f;8t<A
D$49D$
L$`;L$,t1
NlB9Np
;L$@}*
|$t9Np
L$ 9Vp
D$ 9Ap
O2f9K2
C4f;G4
N*f;J*
F(f;B(
t$$;G,u#
BH;FHu
t$(@PV
C,jaQW3
f;C2s?
T$$B;T$
L$0_^[
;D$ rdQ
t59yPt
;Ct~?h$
D$`SVW
D$09Np
D$<9Np
D$8@Pj
D$<9Np
D$89Np
t$<9Op
L$d_^[3
D$L9Vp
D$L9Fp
L$\_^3
u 9wtu
D$,9Np
L$\_^[3
F;t$X|
T$,9Sp
t$D9sp
|$$9Kp
D$8SVW
t)<pt%
@ f;C tiA
A f;F t
up9N4t
tK9N<uF
f;D$0tI
t$ f;B*
H;t$0|
\$(9_p
u$9wtu
D$X;L$
L$X9D$
T$L9ADu&
L$H9H ~W
;D$T|%
D$T9Np
D$T9Np
D$l9Qp
P0f;V0}
D$,9D$ vH
tB;BHt=V
L$t_^[3
L$\_^[3
u$9Ctu
L$L_^3
f;H*})
T$|9G$
f;F*}"
u$9Gtu
|$`9Np
9D$<t);
f;J*}d
T$ 9Wp
f;P*}h
T$ 9Wp
t$0f;0
t$4t0A
tz9^$uu
t2PWP3
D$@SVW
9D$D|S
9D$@vK
V<_^[]
q@f;A*
uz9z8uu
GT#J(#B,
@~-<C}/
L$(9Op
D$(9Gp
@~)<C}
F;t$$|
t$$9Op
D$,9Wp
D$G9Op
L$ RVQ
B,#NP#FT
u.f9D$4w'
D$<+D$,
T$T9T$8
f;0t1A
T$(9Wp
;D$0tF
D$4@Ph
f;D$Ts2
L$\9Op
t$l9q
F,#JP#BT
D$4_^[
L$P#L$
f;F2s93
9L$Pr*h
D$0#N #F$
f#D$Pf
D$Df#D$P
D$\;D$d|
D$h#D$P#T$H
A f;GHt-
L$t9Np
D$X;D$\
D$X;D$\
#T$<#L$@
|$(f;H*}/
L$l9Np
D$09Np
D$09Np
#O #G$
<Hf+|H
#N #F$
{D#p8#x<
u]9S$uX
C0f;A0
D$pf9u
L$(9L$4
@0;8tkA
L$(;L$4
#T$ #L$
D$L;\$xu ;
@D#N@#FD
@~&j@hx
9D$4t[
N,#T$D#L$<
I$;J4u
D$09Op
D$49Op
D$HP?S
|$@9FD
D$P01K
D$T@1K
L$d_^[3
NlB9Np
u 9ytu
u"9wtu
D$,9Np
T$,9Vp
NlB9Np
NlB9Np
T$,9Vp
\$<9^p
D$09Np
D$09Np
D$09Np
P@B9Np
D$09Np
NlB9Np
NlB9Np
NlJ9Np
L$ 9Np
T$ 9Vp
D$,9Np
T$,9Vp
L$p<Vtu<Zt
\$89Np
D$$9^p
L$H9Np
L$P9Np
T$p9Np
T$@9Np
NlJ9Np
T$P9Np
Xu{<Xu
\$L9^p
T$@9Vp
T$P9Np
T$P9Np
L$@^[3
!"#$%&'
()*+,-./0123
:;:3<=>4
?@ABCDE
RSTUVOWXYZ[\
3klmnopqrs
tuvwxy3=
z{|z}}~
<>td<<u
#N #F$
t>hDkY
tHhDkY
t:hDkY
AD#A@Y]
t:hDkY
lhos;J
:modeu(
9\$ t.8
WWWWh0
u@8^Su;8^Tu6
L$$_^[3
URPQQh
;t$,v-
UQPXY]Y[
F4_^[]
<ItC<Lt3<Tt#<h
A<lt'<tt
<ItC<Lt3<Tt#<h
A<lt'<tt
SSSQSP
SVWj03
WWWSHSh
WPWWWS
:u%f9Y
PPPPPPPP
Wj0XPV
SPjdVQ
<at1<rt!<wt
<=upG8
PPPPPWS
PP9E u<PPVWP
uG9]$t
QQSVj8j@
u kE$<
tlj*Yf
SSVWh
f9:t!V
PPPPPPPP
FlsAlloc
FlsFree
FlsSetValue
InitializeCriticalSectionEx
__based(
__cdecl
__pascal
__stdcall
__thiscall
__fastcall
__vectorcall
__clrcall
__eabi
__swift_1
__swift_2
__ptr64
__restrict
__unaligned
restrict(
delete
operator
`vftable'
`vbtable'
`vcall'
`typeof'
`local static guard'
`string'
`vbase destructor'
`vector deleting destructor'
`default constructor closure'
`scalar deleting destructor'
`vector constructor iterator'
`vector destructor iterator'
`vector vbase constructor iterator'
`virtual displacement map'
`eh vector constructor iterator'
`eh vector destructor iterator'
`eh vector vbase constructor iterator'
`copy constructor closure'
`udt returning'
`local vftable'
`local vftable constructor closure'
new[]
delete[]
`omni callsig'
`placement delete closure'
`placement delete[] closure'
`managed vector constructor iterator'
`managed vector destructor iterator'
`eh vector copy constructor iterator'
`eh vector vbase copy constructor iterator'
`dynamic initializer for '
`dynamic atexit destructor for '
`vector copy constructor iterator'
`vector vbase copy constructor iterator'
`managed vector copy constructor iterator'
`local static thread guard'
operator ""
operator co_await
Type Descriptor'
Base Class Descriptor at (
Base Class Array'
Class Hierarchy Descriptor'
Complete Object Locator'
`h````
xpxxxx
(null)
CorExitProcess
cmd.exe
COMSPEC
COMSPEC
cmd.exe
AreFileApisANSI
CompareStringEx
FlsAlloc
FlsFree
FlsGetValue
FlsSetValue
InitializeCriticalSectionEx
LCMapStringEx
LocaleNameToLCID
RoInitialize
RoUninitialize
AppPolicyGetProcessTerminationMethod
AppPolicyGetThreadInitializationType
NAN(SNAN)
nan(snan)
NAN(IND)
nan(ind)
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
August
September
October
November
December
MM/dd/yy
dddd, MMMM dd, yyyy
HH:mm:ss
!"#$%&'()*+,-./0123456789:;<=>?@abcdefghijklmnopqrstuvwxyz[\]^_`abcdefghijklmnopqrstuvwxyz{|}~
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`ABCDEFGHIJKLMNOPQRSTUVWXYZ{|}~
UTF-16LEUNICODE
[aOni*{
~ $s%r
@b;zO]
v2!L.2
1#QNAN
1#SNAN
?5Wg4p
%S#[k =
"B <1=
_hypot
_nextafter
13:27:04
Single block msg
DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD
8- oVX]
""""""""""""""""
""""""""""""""""
<Se>/E
-append append the database to the end of the file
-ascii set output mode to 'ascii'
-bail stop after hitting an error
-batch force batch I/O
-box set output mode to 'box'
-column set output mode to 'column'
-cmd COMMAND run "COMMAND" before reading stdin
-csv set output mode to 'csv'
-echo print commands before execution
-init FILENAME read/process named file
-[no]header turn headers on or off
-help show this message
-html set output mode to HTML
-interactive force interactive I/O
-json set output mode to 'json'
-line set output mode to 'line'
-list set output mode to 'list'
-lookaside SIZE N use N entries of SZ bytes for lookaside memory
-markdown set output mode to 'markdown'
-memtrace trace all memory allocations and deallocations
-mmap N default mmap size set to N
-newline SEP set output row separator. Default: '\n'
-nofollow refuse to open symbolic links to database files
-nullvalue TEXT set text string for NULL values. Default ''
-pagecache SIZE N use N slots of SZ bytes each for page cache memory
-quote set output mode to 'quote'
-readonly open the database read-only
-separator SEP set output column separator. Default: '|'
-stats print memory stats before each finalize
-table set output mode to 'table'
-tabs set output mode to 'tabs'
-version show SQLite version
-vfs NAME use NAME as the default VFS
SQLite format 3
REINDEXEDESCAPEACHECKEYBEFOREIGNOREGEXPLAINSTEADDATABASELECTABLEFTHENDEFERRABLELSEXCLUDELETEMPORARYISNULLSAVEPOINTERSECTIESNOTNULLIKEXCEPTRANSACTIONATURALTERAISEXCLUSIVEXISTSCONSTRAINTOFFSETRIGGERANGENERATEDETACHAVINGLOBEGINNEREFERENCESUNIQUERYWITHOUTERELEASEATTACHBETWEENOTHINGROUPSCASCADEFAULTCASECOLLATECREATECURRENT_DATEIMMEDIATEJOINSERTMATCHPLANALYZEPRAGMATERIALIZEDEFERREDISTINCTUPDATEVALUESVIRTUALWAYSWHENWHERECURSIVEABORTAFTERENAMEANDROPARTITIONAUTOINCREMENTCASTCOLUMNCOMMITCONFLICTCROSSCURRENT_TIMESTAMPRECEDINGFAILASTFILTEREPLACEFIRSTFOLLOWINGFROMFULLIMITIFORDERESTRICTOTHERSOVERETURNINGRIGHTROLLBACKROWSUNBOUNDEDUNIONUSINGVACUUMVIEWINDOWBYINITIALLYPRIMARY
onoffalseyestruextrafull
nth_value
':){C!
%uddUX*T
last_value
0123456789ABCDEF0123456789abcdef
******""""""""""""""""""""
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@3.35.5
dense_rank
BINARY
!!""##$$%%&&''(())**++,,--..//00112233445566778899
!"#$%&'()*+,-./0123456789:;<=>?@abcdefghijklmnopqrstuvwxyz[\]^_`abcdefghijklmnopqrstuvwxyz{|}~
first_value
0123456789ABCDEF
naturaleftouterightfullinnercross
&&&&&&&&&&
SQLite format 3
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789
percent_rank
thstndrd
row_number
cume_dist
Mb@?-C
C.l`u Z0
r!*9>Q
mIzD,`
`k x,e
0gKQ}>
Lmjv86#D
Oju'rV
R0F^5%
;jq#[%
K5R8haM
7))|&U
d;+l"Q>=
mLDjjlo
h{6bs[
h{6bs[
V>s*G-,eR
wzGUv-d
v[<Om.GwCP
p1bF%B>
IA>5p?
;Q=cx
kkD2>H
86`eO5
;W2BwD
HT/s7%
uYd*3rC
+T.C(_
>0}|WB
./Ql]U
NK#\J"
AhU9`'
{63;Zj
is6_QM
{63;Z&
gVgiHp
q8QWPz;
ci[=iO
Ui@6)!
]VI+\G
;6vb%};9
;^+K{t
T>1$_{
)WLToi
No#Wj(=
:^D?|7
X`iM_K
p,MMbW/
FzPnH,!
GSEqK1
Jzr+dd
WKQ?odc
I=I'^C
~'\J,%"
[u[yAx
>@\#MJ
s`8/%G
I?L%3j
QY$d7~
xiE jN
#!Gyl!x
W]W>Me0wQ
!{~T a2
aM!|sW
Va0HVS[
.kS>86U
qqr]/8
7F#G)"fR
e/GJ1g
EU]+;tI
f3@E8d
Z~G_DT
." #)`
Br['k"
\A0?&e
wR"&>!
H~yNml
lHZ|96
m&CQPo
_A*nf1
JdDP r
iPswt=
\fLo/ e
#\-]h,
J/`rMn
X;7]2w
K&.Tf"?
\&#d=W
I@[N@5
X}]3H-
U)s|s@
D-M^cn
<&SkZHx
:}Qfy\
bATd *
Ok=H1'H
G^d' @
WadYJh
V_iMo.
!5jFM3B
@NGt!:
s?4'(&o
x1 QYaG
M9 B;;
0s_U+{*;P
~;N>La
e_enz;^0
d?i_a,3
@p3Lcp*
v5DcdE
f^~(^|5~4u
`#.IOF
I)02EZ
(jt#U^ss
:6R#PI
Iz`>)R
tBz.z~
KP#I2{
O|Y7AY
!Vu!pZ
@L&:3j@
s-Xsp`7
=?,9A]
.3z[t"
o&S\Fc
j.XS"Z
],BvWJ.
+0Fr?#
_/Wo4J>
s7"Jk2
:POn1eW
<uL/tR
U#B1 `Pr
u*A>2L\a
+zREk.8
z>Qz[s
A[RC2Y
62w{g_l
G[( GIa
{*pXzx
.bm=B@
p}on(0
YMl#$I
wlDeQ\
wz`[(1
bB%,R1
bB%,R1
LU(<QX
:QIB8a
C0{zcO
2CzTnBa_(s
Hk!+k/
AA*]C_!
J.yiuP
&K8fyq=$T
q&HW'to
#17*{M
N}pHjf
'_H([6-
Wxm<N!W
)k xW]y'
~;TE&o
feOL"4
m!PgGY
z:>qcs
\B8;^O
Lw>he%
3eftWb
hMOAa=
F@|/"G
d/8pf9
CFsmmL
o*?Yhr
g`.(|@
hl GD7
hV!^Wjf
9,n+u\
l,5TQ+g
+@D{`LD}W4
g:4@Tw/
L}-Veu
w./# ,
rNH5X)
*\n8Pq
EorNlE
5zMA[q
FdJ"{Q6!
^9I]heg
ASYC2X
0`B]ck=
?2?Xh!e
ASYC2X
*\n8Pq
EorNlE
DpxG#G
DpxG#G
$_r/Go
eL.Lpe
'&F}6
z{a8%V~+
Y<c T7[
&K^!A5
+;fBss
)!teNz
/i{Y,J
#IG0_9
[wZBhi
-t}q8|
04o%*Qe
Mq4N ]
[3dGA3
XBA2 e
b%%oed
b#blPf
6X4 G9
p5-ieq
Ff2ag\j
qCH"HKn
'3f15
GetProcessTimes
Run Time: real %.3f user %f sys %f
Error: out of memory
PRAGMA "%w".table_info=%Q;
/* %s */
UNIQUE INDEX
TRIGGER
VIRTUAL TABLE
CREATE
%.*s "%w".%s
%.*s %s.%s
/* %s */
/* %s */
SystemDrive
SHA3 size should be one of: 224 256 384 512
error SQL statement [%s]: %s
non-query: [%s]
sha3_query
wrong number of arguments to function writefile()
failed to create directory: %s
failed to write file: %s
CREATE TABLE x(name,mode,mtime,data,path HIDDEN,dir HIDDEN)
cannot read directory: %s
cannot stat file: %s
table function fsdir requires an argument
table function fsdir requires a non-NULL argument
readfile
writefile
lsmode
CREATE TABLE x( candidate TEXT, prefix TEXT HIDDEN, wholeline TEXT HIDDEN, phase INT HIDDEN)
PRAGMA database_list
%z%sSELECT name FROM "%w".sqlite_schema
UNION
%z%sSELECT pti.name FROM "%w".sqlite_schema AS sm JOIN pragma_table_info(sm.name,%Q) AS pti WHERE sm.type='table'
completion
apndvfs
Start-Of-SQLite3-
apnd(%lld)/%z
MEMTRACE: allocate %d bytes
MEMTRACE: free %d bytes
MEMTRACE: resize %d -> %d bytes
decimal
decimal_cmp
decimal_add
decimal_sub
decimal_mul
decimal_sum
ieee754(%lld,%d)
ieee754
ieee754_mantissa
ieee754_exponent
ieee754_to_blob
ieee754_from_blob
CREATE TABLE x(value,start hidden,stop hidden,step hidden)
generate_series
internal error!
SELECT * FROM main.%Q WHERE sample()
expert
PRAGMA table_xinfo=%Q
COLLATE %Q
COLLATE %s
PRAGMA index_list=%Q
PRAGMA index_xInfo=%Q
%s_idx_%08x
CREATE INDEX '%q' ON %Q(%s)
CREATE INDEX %s ON %s(%s)
EXPLAIN QUERY PLAN %s
USING INDEX
USING COVERING INDEX
t592690916721053953805701627921227776
DROP TABLE t592690916721053953805701627921227776
SELECT 'CREATE TEMP' || substr(sql, 7) FROM sqlite_schema WHERE tbl_name = %Q AND type IN ('table', 'trigger') ORDER BY type;
ALTER TABLE temp.%Q RENAME TO %Q
INSERT INTO %Q VALUES(
UPDATE %Q SET
%s%Q=?
DELETE FROM %Q
SELECT type, name, sql, 1 FROM sqlite_schema WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%%' UNION ALL SELECT type, name, sql, 2 FROM sqlite_schema WHERE type = 'trigger' AND tbl_name IN(SELECT name FROM sqlite_schema WHERE type = 'view') ORDER BY 4, 1
CREATE TABLE x(
%s%Q COLLATE %s
CREATE VIRTUAL TABLE %Q USING expert(%Q)
SELECT max(i.seqno) FROM sqlite_schema AS s, pragma_index_list(s.name) AS l, pragma_index_info(l.name) AS i WHERE s.type = 'table'
%sx.%Q IS rem(%d, x.%Q) COLLATE %s
SELECT %s FROM %Q x ORDER BY %s
SELECT %s FROM temp.t592690916721053953805701627921227776 x ORDER BY %s
DROP TABLE IF EXISTS temp.t592690916721053953805701627921227776
CREATE TABLE temp.t592690916721053953805701627921227776 AS SELECT * FROM %Q
SELECT s.rowid, s.name, l.name FROM sqlite_schema AS s, pragma_index_list(s.name) AS l WHERE s.type = 'table'
SELECT name, coll FROM pragma_index_xinfo(?) WHERE key
INSERT INTO sqlite_stat1 VALUES(?, ?, ?)
ANALYZE; PRAGMA writable_schema=1
sample
ANALYZE sqlite_schema
:memory:
SELECT sql FROM sqlite_schema WHERE name NOT LIKE 'sqlite_%%' AND sql NOT LIKE 'CREATE VIRTUAL %%'
-- stat1:
%s;%s%s
column
insert
explain
prettyprint
markdown
(%d) %s
VISUAL
no editor for edit()
NULL input to edit()
temp%llx
edit() cannot open temp file
edit() could not write the whole file
%s "%s"
EDITOR returned non-zero
edit() cannot reopen temp file after edit
could not read back the whole file
(%s%u)
replace(
,'%s',char(13))
,'%s',char(10))
"
CREATE_INDEX
CREATE_TABLE
CREATE_TEMP_INDEX
CREATE_TEMP_TABLE
CREATE_TEMP_TRIGGER
CREATE_TEMP_VIEW
CREATE_TRIGGER
CREATE_VIEW
DELETE
DROP_INDEX
DROP_TABLE
DROP_TEMP_INDEX
DROP_TEMP_TABLE
DROP_TEMP_TRIGGER
DROP_TEMP_VIEW
DROP_TRIGGER
DROP_VIEW
INSERT
PRAGMA
SELECT
TRANSACTION
UPDATE
ATTACH
DETACH
ALTER_TABLE
REINDEX
ANALYZE
CREATE_VTABLE
DROP_VTABLE
FUNCTION
SAVEPOINT
RECURSIVE
authorizer: %s
CREATE TABLE ['"]*
CREATE TABLE IF NOT EXISTS %s%s
%d,%d,%s
%s%s%s
QUERY PLAN
Progress limit reached (%u)
Progress %u
--------------------------------------------------
%*s = %s%s
CREATE VIEW%
CREATE TRIG%
INSERT INTO %s
VALUES(
-1e999
%!.20g
SAVEPOINT selftest_init;
CREATE TABLE IF NOT EXISTS selftest(
tno INTEGER PRIMARY KEY,
op TEXT,
cmd TEXT,
ans TEXT
);CREATE TEMP TABLE [_shell$self](op,cmd,ans);
INSERT INTO [_shell$self](rowid,op,cmd)
VALUES(coalesce((SELECT (max(tno)+100)/10 FROM selftest),10),
'memo','Tests generated by --init');
INSERT INTO [_shell$self]
SELECT 'run',
'SELECT hex(sha3_query(''SELECT type,name,tbl_name,sql FROM sqlite_schema ORDER BY 2'',224))',
hex(sha3_query('SELECT type,name,tbl_name,sql FROM sqlite_schema ORDER BY 2',224));
INSERT INTO [_shell$self]
SELECT 'run', 'SELECT hex(sha3_query(''SELECT * FROM "' || printf('%w',name) || '" NOT INDEXED'',224))',
hex(sha3_query(printf('SELECT * FROM "%w" NOT INDEXED',name),224))
FROM (
SELECT name FROM sqlite_schema
WHERE type='table'
AND name<>'selftest'
AND coalesce(rootpage,0)>0
ORDER BY name;
INSERT INTO [_shell$self]
VALUES('run','PRAGMA integrity_check','ok');
INSERT INTO selftest(tno,op,cmd,ans) SELECT rowid*10,op,cmd,ans FROM [_shell$self];
DROP TABLE [_shell$self];
SELFTEST initialization failure: %s
RELEASE selftest_init
/**** ERROR: (%d) %s *****/
%-36s %s
Number of output columns:
%-36s %d
Column %d %nname:
declared type:
VM-steps: %d
%lld (max %lld) bytes
Memory Used:
%lld (max %lld)
Number of Outstanding Allocations:
%lld (max %lld) pages
Number of Pcache Pages Used:
Number of Pcache Overflow Bytes:
%lld bytes
Largest Allocation:
Largest Pcache Allocation:
Lookaside Slots Used: %d (max %d)
Successful lookaside attempts: %d
Lookaside failures due to size: %d
Lookaside failures due to OOM: %d
Pager Heap Usage: %d bytes
Page cache hits: %d
Page cache misses: %d
Page cache writes: %d
Page cache spills: %d
Schema Heap Usage: %d bytes
Statement Heap/Lookaside Usage: %d bytes
Fullscan Steps: %d
Sort Operations: %d
Autoindex Inserts: %d
Virtual Machine Steps: %d
Reprepare operations: %d
Number of times run: %d
Memory used by prepared stmt: %d
SorterNext
SeekLT
SeekGT
RowSetRead
Rewind
opcode
comment
CREATE TABLE IF NOT EXISTS temp.sqlite_parameters(
key TEXT PRIMARY KEY,
value ANY
) WITHOUT ROWID;
sqlite_parameters
SELECT value FROM temp.sqlite_parameters WHERE key=?1
%*s%s%*s
%*s%s%*s%s
Interrupt
-- Candidates -----------------------------
(no new indexes)
-- Query %d --------------------------------
-verbose
-sample
option requires an argument: %s
value out of range: %s
unknown option: %s
sqlite3_expert_new: %s
EXPLAIN %s
PRAGMA table_info=%Q
INTEGER
SELECT 1 FROM pragma_index_list(%Q) WHERE origin='pk'
_rowid_
PRAGMA reverse_unordered_selects
PRAGMA reverse_unordered_selects(%d)
sqlite_sequence
DELETE FROM sqlite_sequence;
sqlite_stat?
ANALYZE sqlite_schema;
sqlite_
CREATE VIRTUAL TABLE
PRAGMA writable_schema=ON;
INSERT INTO sqlite_schema(type,name,tbl_name,rootpage,sql)VALUES('table','%q','%q',0,'%q');
SELECT
FROM
/****** CORRUPTION ERROR *******/
/****** %s ******/
%s ORDER BY rowid DESC
/****** ERROR: %s ******/
.auth ON|OFF Show authorizer callbacks
.backup ?DB? FILE Backup DB (default "main") to FILE
--append Use the appendvfs
--async Write to FILE without journal and fsync()
.bail on|off Stop after hitting an error. Default OFF
.binary on|off Turn binary output on or off. Default OFF
.cd DIRECTORY Change the working directory to DIRECTORY
.changes on|off Show number of rows changed by SQL
.check GLOB Fail if output since .testcase does not match
.clone NEWDB Clone data into NEWDB from the existing database
.databases List names and files of attached databases
.dbconfig ?op? ?val? List or change sqlite3_db_config() options
.dbinfo ?DB? Show status information about the database
.dump ?OBJECTS? Render database content as SQL
Options:
--data-only Output only INSERT statements
--newlines Allow unescaped newline characters in output
--nosys Omit system tables (ex: "sqlite_stat1")
--preserve-rowids Include ROWID values in the output
OBJECTS is a LIKE pattern for tables, indexes, triggers or views to dump
Additional LIKE patterns can be given in subsequent arguments
.echo on|off Turn command echo on or off
.eqp on|off|full|... Enable or disable automatic EXPLAIN QUERY PLAN
Other Modes:
trigger Like "full" but also show trigger bytecode
.excel Display the output of next command in spreadsheet
--bom Put a UTF8 byte-order mark on intermediate file
.exit ?CODE? Exit this program with return-code CODE
.expert EXPERIMENTAL. Suggest indexes for queries
.explain ?on|off|auto? Change the EXPLAIN formatting mode. Default: auto
.filectrl CMD ... Run various sqlite3_file_control() operations
--schema SCHEMA Use SCHEMA instead of "main"
--help Show CMD details
.fullschema ?--indent? Show schema and the content of sqlite_stat tables
.headers on|off Turn display of headers on or off
.help ?-all? ?PATTERN? Show help text for PATTERN
.import FILE TABLE Import data from FILE into TABLE
--ascii Use \037 and \036 as column and row separators
--csv Use , and \n as column and row separators
--skip N Skip the first N rows of input
-v "Verbose" - increase auxiliary output
Notes:
* If TABLE does not exist, it is created. The first row of input
determines the column names.
* If neither --csv or --ascii are used, the input mode is derived
from the ".mode" output mode
* If FILE begins with "|" then it is a command that generates the
input text.
.imposter INDEX TABLE Create imposter table TABLE on index INDEX
.indexes ?TABLE? Show names of indexes
If TABLE is specified, only show indexes for
tables matching TABLE using the LIKE operator.
.limit ?LIMIT? ?VAL? Display or change the value of an SQLITE_LIMIT
.lint OPTIONS Report potential schema issues.
Options:
fkey-indexes Find missing foreign key indexes
.load FILE ?ENTRY? Load an extension library
.log FILE|off Turn logging on or off. FILE can be stderr/stdout
.mode MODE ?TABLE? Set output mode
MODE is one of:
ascii Columns/rows delimited by 0x1F and 0x1E
box Tables using unicode box-drawing characters
csv Comma-separated values
column Output in columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
json Results in a JSON array
line One value per line
list Values delimited by "|"
markdown Markdown table format
quote Escape answers as for SQL
table ASCII-art table
tabs Tab-separated values
tcl TCL list elements
.nullvalue STRING Use STRING in place of NULL values
.once ?OPTIONS? ?FILE? Output for the next SQL command only to FILE
If FILE begins with '|' then open as a pipe
--bom Put a UTF8 byte-order mark at the beginning
-e Send output to the system text editor
-x Send output as CSV to a spreadsheet (same as ".excel")
.open ?OPTIONS? ?FILE? Close existing database and reopen FILE
--append Use appendvfs to append database to the end of FILE
--new Initialize FILE to an empty database
--nofollow Do not follow symbolic links
--readonly Open FILE readonly
--zip FILE is a ZIP archive
.output ?FILE? Send output to FILE or stdout if FILE is omitted
If FILE begins with '|' then open it as a pipe.
--bom Prefix output with a UTF8 byte-order mark
-e Send output to the system text editor
-x Send output as CSV to a spreadsheet
.parameter CMD ... Manage SQL parameter bindings
clear Erase all bindings
init Initialize the TEMP table that holds bindings
list List the current parameter bindings
set PARAMETER VALUE Given SQL parameter PARAMETER a value of VALUE
PARAMETER should start with one of: $ : @ ?
unset PARAMETER Remove PARAMETER from the binding table
.print STRING... Print literal STRING
.progress N Invoke progress handler after every N opcodes
--limit N Interrupt after N progress callbacks
--once Do no more than one progress interrupt
--quiet|-q No output except at interrupts
--reset Reset the count for each input and interrupt
.prompt MAIN CONTINUE Replace the standard prompts
.quit Exit this program
.read FILE Read input from FILE
.restore ?DB? FILE Restore content of DB (default "main") from FILE
.save FILE Write in-memory database into FILE
.scanstats on|off Turn sqlite3_stmt_scanstatus() metrics on or off
.schema ?PATTERN? Show the CREATE statements matching PATTERN
--indent Try to pretty-print the schema
--nosys Omit objects whose names start with "sqlite_"
.selftest ?OPTIONS? Run tests defined in the SELFTEST table
Options:
--init Create a new SELFTEST table
-v Verbose output
.separator COL ?ROW? Change the column and row separators
.sha3sum ... Compute a SHA3 hash of database content
--schema Also hash the sqlite_schema table
--sha3-224 Use the sha3-224 algorithm
--sha3-256 Use the sha3-256 algorithm (default)
--sha3-384 Use the sha3-384 algorithm
--sha3-512 Use the sha3-512 algorithm
Any other argument is a LIKE pattern for tables to hash
.shell CMD ARGS... Run CMD ARGS... in a system shell
.show Show the current values for various settings
.stats ?ARG? Show stats or turn stats on or off
off Turn off automatic stat display
on Turn on automatic stat display
stmt Show statement stats
vmstep Show the virtual machine step count only
.system CMD ARGS... Run CMD ARGS... in a system shell
.tables ?TABLE? List names of tables matching LIKE pattern TABLE
.testcase NAME Begin redirecting output to 'testcase-out.txt'
.testctrl CMD ... Run various sqlite3_test_control() operations
Run ".testctrl" with no arguments for details
.timeout MS Try opening locked tables for MS milliseconds
.timer on|off Turn SQL timer on or off
.trace ?OPTIONS? Output each SQL statement as it is run
FILE Send output to FILE
stdout Send output to stdout
stderr Send output to stderr
off Disable tracing
--expanded Expand query parameters
--plain Show SQL as it is input
--stmt Trace statement execution (SQLITE_TRACE_STMT)
--profile Profile statements (SQLITE_TRACE_PROFILE)
--row Trace each row (SQLITE_TRACE_ROW)
--close Trace connection close (SQLITE_TRACE_CLOSE)
.vfsinfo ?AUX? Information about the top-level VFS
.vfslist List all available VFSes
.vfsname ?AUX? Print the name of the VFS stack
.width NUM1 NUM2 ... Set minimum column widths for columnar output
Negative values right-justify
%%%s%%
SQLite format 3
replace(replace(
', char(10))
', char(13))
Error: unable to open database "%s": %s
shell_add_schema
shell_module_schema
shell_putsnl
shell_escape_crnl
shell_int32
shell_idquote
usleep
CREATE VIRTUAL TABLE zip USING zipfile(%Q);
Error: sqlite3_close() returns %d: %s
ERROR: Not a boolean value: "%s". Assuming "no".
stdout
stderr
Error: cannot open "%s"
-- closing database connection
%.*s; -- %lld ns
%s:%d: unescaped %c character
%s:%d: unterminated %c-quoted field
SELECT * FROM "%w"
Error %d: %s on [%s]
INSERT OR IGNORE INTO "%s" VALUES(?
Error %d: %s
SELECT * FROM "%w" ORDER BY rowid DESC;
Warning: cannot step "%s" backwards
SELECT name, sql FROM sqlite_schema WHERE %s
Error: (%d) %s on [%s]
%s...
Error: %s
SQL: [%s]
SELECT name, sql FROM sqlite_schema WHERE %s ORDER BY rowid DESC
File "%s" already exists.
Cannot create output database: %s
PRAGMA writable_schema=ON;
BEGIN EXCLUSIVE;
type='table'
type!='table'
COMMIT;
PRAGMA writable_schema=OFF;
Failed: [%s]
file change counter:
database page count:
freelist page count:
schema cookie:
schema format:
default cache size:
autovacuum top root:
incremental vacuum:
text encoding:
user version:
application id:
software version:
number of tables:
SELECT count(*) FROM %s WHERE type='table'
number of indexes:
SELECT count(*) FROM %s WHERE type='index'
number of triggers:
SELECT count(*) FROM %s WHERE type='trigger'
number of views:
SELECT count(*) FROM %s WHERE type='view'
schema size:
SELECT total(length(sql)) FROM %s
SELECT data FROM sqlite_dbpage(?1) WHERE pgno=1
error: %s
unable to read database header
database page size:
%-20s %d
write format:
read format:
reserved bytes:
%-20s %u
(utf8)
(utf16le)
(utf16be)
main.sqlite_schema
sqlite_temp_schema
"%w".sqlite_schema
data version
%-20s %u
Error: %s
%s/temp%llx.%s
out of memory
SELECT 'EXPLAIN QUERY PLAN SELECT 1 FROM ' || quote(s.name) || ' WHERE ' || group_concat(quote(s.name) || '.' || quote(f.[from]) || '=?' || fkey_collate_clause( f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]),' AND '), 'SEARCH TABLE ' || s.name || ' USING COVERING INDEX*(' || group_concat('*=?', ' AND ') || ')', s.name || '(' || group_concat(f.[from], ', ') || ')', f.[table] || '(' || group_concat(COALESCE(f.[to], p.[name])) || ')', 'CREATE INDEX ' || quote(s.name ||'_'|| group_concat(f.[from], '_')) || ' ON ' || quote(s.name) || '(' || group_concat(quote(f.[from]) || fkey_collate_clause( f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]), ', ') || ');', f.[table] FROM sqlite_schema AS s, pragma_foreign_key_list(s.name) AS f LEFT JOIN pragma_table_info AS p ON (pk-1=seq AND p.arg=f.[table]) GROUP BY s.name, f.id ORDER BY (CASE WHEN ? THEN f.[table] ELSE s.name END)
SEARCH TABLE * USING INTEGER PRIMARY KEY (rowid=?)
-groupbyparent
Usage: %s %s ?-verbose? ?-groupbyparent?
fkey_collate_clause
Error: internal error
-- Parent table %s
%s%s --> %s
%s/* no extra indexes required for %s -> %s */
fkey-indexes
Usage %s sub-command ?switches...?
Where sub-commands are:
fkey-indexes
Usage: .auth ON|OFF
backup
-append
-async
Usage: .backup ?DB? ?OPTIONS? FILENAME
missing FILENAME argument on .backup
PRAGMA synchronous=OFF; PRAGMA journal_mode=OFF;
Usage: .bail on|off
binary
Usage: .binary on|off
Cannot change to directory "%s"
Usage: .cd DIRECTORY
breakpoint
changes
Usage: .changes on|off
Usage: .check GLOB-PATTERN
testcase-out.txt
Error: cannot read 'testcase-out.txt'
testcase-%s FAILED
Expected: [%s]
Got: [%s]
testcase-%s ok
Usage: .clone FILENAME
databases
read-txn
write-txn
%s: %s %s%s
dbconfig
defensive
dqs_ddl
dqs_dml
enable_fkey
enable_qpsg
enable_trigger
enable_view
fts3_tokenizer
legacy_alter_table
legacy_file_format
load_extension
no_ckpt_on_close
reset_database
trigger_eqp
trusted_schema
writable_schema
%19s %s
Error: unknown dbconfig "%s"
Enter ".dbconfig" with no arguments for a list
dbinfo
preserve-rowids
newlines
data-only
Unknown option "%s" on ".dump"
%z OR name LIKE %Q ESCAPE '\'
name LIKE %Q ESCAPE '\'
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
SAVEPOINT dump; PRAGMA writable_schema=ON
SELECT name, type, sql FROM sqlite_schema WHERE (%s) AND type=='table' AND sql NOT NULL ORDER BY tbl_name='sqlite_sequence', rowid
SELECT sql FROM sqlite_schema WHERE (%s) AND sql NOT NULL AND type IN ('index','trigger','view')
PRAGMA writable_schema=OFF;
RELEASE dump;
ROLLBACK; -- due to errors
COMMIT;
Usage: .echo on|off
PRAGMA vdbe_trace=OFF;
trigger
Usage: .eqp off|on|trace|trigger|full
filectrl
chunk_size
data_version
has_moved
lock_timeout
MILLISEC
persist_wal
[BOOLEAN]
reserve_bytes
size_limit
[LIMIT]
tempfilename
--schema
-schema
Available file-controls:
.filectrl %s %s
Error: ambiguous file-control: "%s"
Use ".filectrl --help" for help
Error: unknown file-control: %s
Use ".filectrl --help" for help
Usage: .filectrl %s %s
fullschema
indent
Usage: .fullschema ?--indent?
SELECT sql FROM (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x FROM sqlite_schema UNION ALL SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_schema) WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' ORDER BY rowid
SELECT rowid FROM sqlite_schema WHERE name GLOB 'sqlite_stat[134]'
/* No STAT tables available */
SELECT 'ANALYZE sqlite_schema'
sqlite_stat1
SELECT * FROM sqlite_stat1
sqlite_stat4
SELECT * FROM sqlite_stat4
headers
Usage: .headers on|off
Nothing matches '%s'
import
ERROR: extra argument: "%s". Usage:
-ascii
ERROR: unknown option: "%s". Usage:
ERROR: missing %s argument. Usage:
Error: non-null column separator required for import
Error: multi-character column separators not allowed for import
Error: non-null row separator required for import
Error: multi-character row separators not allowed for import
<pipe>
Column separator
, row separator
no such table: *
CREATE TABLE "%w"
"%w" TEXT
%s: empty file
CREATE TABLE "%s"(...) failed: %s
INSERT INTO "%w" VALUES(?
Insert using: %s
%s:%d: expected %d columns but found %d - filling the rest with NULL
%s:%d: expected %d columns but found %d - extras ignored
%s:%d: INSERT failed: %s
COMMIT
Added %d rows with %d errors using %d lines of input
imposter
Usage: .imposter INDEX IMPOSTER
.imposter off
SELECT rootpage, 0 FROM sqlite_schema WHERE name='%q' AND type='index'UNION ALL SELECT rootpage, 1 FROM sqlite_schema WHERE name='%q' AND type='table' AND sql LIKE '%%without%%rowid%%'
PRAGMA index_xinfo='%q'
_ROWID_
expr%d
%z,"%w"
no such index: "%s"
CREATE TABLE "%w"(%s,PRIMARY KEY(%.*s))WITHOUT ROWID
Error in [%s]: %s
WARNING: writing to an imposter table will corrupt the "%s" %s!
SQLITE_TESTCTRL_IMPOSTER returns %d
limits
length
sql_length
expr_depth
compound_select
vdbe_op
function_arg
attached
like_pattern_length
variable_number
trigger_depth
worker_threads
%20s %d
Usage: .limit NAME ?NEW-VALUE?
ambiguous limit: "%s"
unknown limit: "%s"
enter ".limits" with no arguments for a list.
Usage: .load FILE ?ENTRYPOINT?
Usage: .log FILENAME
columns
current output mode: %s
Error: mode should be one of: ascii box column csv html insert json line list markdown quote table tabs tcl
nullvalue
Usage: .nullvalue STRING
append
readonly
nofollow
extra argument: "%s"
Error: cannot open '%s'
output
ERROR: extra parameter: "%s". Usage:
Error: cannot open pipe "%s"
Error: cannot write to "%s"
parameter
DROP TABLE IF EXISTS temp.sqlite_parameters;
SELECT max(length(key)) FROM temp.sqlite_parameters;
SELECT key, quote(value) FROM temp.sqlite_parameters;
%-*s %s
REPLACE INTO temp.sqlite_parameters(key,value)VALUES(%Q,%s);
REPLACE INTO temp.sqlite_parameters(key,value)VALUES(%Q,%Q);
DELETE FROM temp.sqlite_parameters WHERE key=%Q
progress
Error: missing argument on --limit
Error: unknown option: "%s"
prompt
Usage: .read FILE
restore
Usage: .restore ?DB? FILE
Error: source database is busy
scanstats
Warning: .scanstats not available in this build.
Usage: .scanstats on|off
schema
Unknown option: "%s"
Usage: .schema ?--indent? ?--nosys? ?LIKE-PATTERN?
sqlite_master
sqlite_schema
sqlite_temp_master
CREATE TABLE %s (
type text,
name text,
tbl_name text,
rootpage integer,
sql text
SELECT name FROM pragma_database_list
SELECT sql FROM
UNION ALL
SELECT shell_add_schema(sql,
,name) AS sql, type, tbl_name, name, rowid,
AS snum,
AS sname FROM
.sqlite_schema
UNION ALL SELECT shell_module_schema(name), 'table', name, name, name, 9e+99, 'main' FROM pragma_module_list
) WHERE
lower(printf('%s.%s',sname,tbl_name))
lower(tbl_name)
GLOB
LIKE
ESCAPE '\'
name NOT LIKE 'sqlite_%%' AND
sql IS NOT NULL ORDER BY snum, rowid
SQL: %s;
Error: querying schema information
selecttrace
selftest
Unknown option "%s" on "%s"
Should be one of: --init -v
SELECT tno,op,cmd,ans FROM selftest ORDER BY tno
VALUES(0,'memo','Missing SELFTEST table - default checks only',''), (1,'run','PRAGMA integrity_check','ok')
Error querying the selftest table
%d: %s %s
Result: %s
%d: error-code-%d: %s
%d: Expected: [%s]
%d: Got: [%s]
Unknown operation "%s" on selftest line %d
%d errors out of %d tests
separator
Usage: .separator COL ?ROW?
sha3sum
sha3-224
sha3-256
sha3-384
sha3-512
Usage: .sha3sum ?OPTIONS? ?LIKE-PATTERN?
sqlite\_%
SELECT lower(name) FROM sqlite_schema WHERE type='table' AND coalesce(rootpage,0)>1 UNION ALL SELECT 'sqlite_schema' ORDER BY 1 collate nocase
SELECT lower(name) FROM sqlite_schema WHERE type='table' AND coalesce(rootpage,0)>1 AND name NOT LIKE 'sqlite_%' ORDER BY 1 collate nocase
WITH [sha3sum$query](a,b) AS(
VALUES(
SELECT * FROM
NOT INDEXED;
SELECT type,name,tbl_name,sql FROM sqlite_schema ORDER BY name;
SELECT name,seq FROM sqlite_sequence ORDER BY name;
SELECT tbl,idx,stat FROM sqlite_stat1 ORDER BY tbl,idx;
ORDER BY tbl, idx, rowid;
%s)) SELECT lower(hex(sha3_query(a,%d))) AS hash, b AS label FROM [sha3sum$query]
%s)) SELECT lower(hex(sha3_query(group_concat(a,''),%d))) AS hash FROM [sha3sum$query]
system
Usage: .system COMMAND
%z "%s"
System command returns %d
Usage: .show
%12.12s: %s
%12.12s:
colseparator
rowseparator
vmstep
filename
Usage: .stats ?on|off|stmt|vmstep?
tables
indices
indexes
Usage: .indexes ?LIKE-PATTERN?
SELECT name FROM
||'.'||name FROM
.sqlite_schema
WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' AND name LIKE ?1
WHERE type='index' AND tbl_name LIKE ?1
ORDER BY 1
%s%-*s
testcase
Error: cannot open 'testcase-out.txt'
testctrl
always
BOOLEAN
assert
byteorder
extra_schema_checks
SCHEMA ON/OFF ROOTPAGE
internal_functions
localtime_fault
never_corrupt
optimizations