SQLite3に.showコマンドで現在の設定内容を確認する

環境
Windows10 64bit
SQLite3.36

操作方法
1.各種設定項目に現在設定されている値を確認する

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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.設定内容を確認します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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

 

SQLite

Posted by arkgame