SQLite3に.showコマンドで現在の設定内容を確認する
環境
Windows10 64bit
SQLite3.36
操作方法
1.各種設定項目に現在設定されている値を確認する
sqlite> .show
echo: off
eqp: off
explain: auto
headers: off
mode: list
nullvalue: ""
output: stdout
colseparator: "|"
rowseparator: "\n"
stats: off
width:
filename: arkgame.sqlie3
sqlite> .show
echo: off
eqp: off
explain: auto
headers: off
mode: list
nullvalue: ""
output: stdout
colseparator: "|"
rowseparator: "\n"
stats: off
width:
filename: arkgame.sqlie3
sqlite> .show echo: off eqp: off explain: auto headers: off mode: list nullvalue: "" output: stdout colseparator: "|" rowseparator: "\n" stats: off width: filename: arkgame.sqlie3
2.modeの項目を変更します
sqlite> .mode csv
3.設定内容を確認します
sqlite> .show
echo: off
eqp: off
explain: auto
headers: off
mode: csv
nullvalue: ""
output: stdout
colseparator: ","
rowseparator: "\r\n"
stats: off
width:
filename: arkgame.sqlie3
sqlite> .show
echo: off
eqp: off
explain: auto
headers: off
mode: csv
nullvalue: ""
output: stdout
colseparator: ","
rowseparator: "\r\n"
stats: off
width:
filename: arkgame.sqlie3
sqlite> .show echo: off eqp: off explain: auto headers: off mode: csv nullvalue: "" output: stdout colseparator: "," rowseparator: "\r\n" stats: off width: filename: arkgame.sqlie3