如何更改选择输出的格式（sqlite）

Question

在 sqlite 上，我显示了表“用户” 如下所示，但选择的输出 均未得到很好的形式，因此很难看到：

sqlite> .header on
sqlite> select * from user;
id|first_name|last_name|age
1|Steve|Jobs|56
2|Bill|Gates|66
3|Mark|Zuckerberg|38

我想要更良好的选择输出如下所示或选择的任何格式都可以，只要格式比上面更好：

id|first_name|last_name |age
1 |Steve     |Jobs      |56
2 |Bill      |Gates     |66
3 |Mark      |Zuckerberg|38

有什么方法可以改变选择输出的格式？

Answer 1

下面的此命令设置输出模式“ box” ：

.mode box

然后，这就是下面的样子：

sqlite> .header on
sqlite> select * from user;
┌────┬────────────┬────────────┬─────┐
│ id │ first_name │ last_name  │ age │
├────┼────────────┼────────────┼─────┤
│ 1  │ Steve      │ Jobs       │ 56  │
│ 2  │ Bill       │ Gates      │ 66  │
│ 3  │ Mark       │ Zuckerberg │ 38  │
└────┴────────────┴────────────┴─────┘

和，下面的此命令集 输出模式“表” ：

.mode table

然后，然后，然后这就是下面的样子：

sqlite> .header on
sqlite> select * from user;
+----+------------+------------+-----+
| id | first_name | last_name  | age |
+----+------------+------------+-----+
| 1  | Steve      | Jobs       | 56  |
| 2  | Bill       | Gates      | 66  |
| 3  | Mark       | Zuckerberg | 38  |
+----+------------+------------+-----+

总共有 14个输出模式，如下所示：

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
qbox        Shorthand for "box --width 60 --quote"
quote       Escape answers as for SQL
table       ASCII-art table
tabs        Tab-separated values
tcl         TCL list elements

这些命令显示了命令“ .mode” ：

.help .mode

或：

.help mode

然后 ： ，这就是下面的样子：

sqlite> .help .mode
.import FILE TABLE       Import data from FILE into TABLE
   Options:
     --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
     --schema S            Target table to be S.TABLE
     -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.
.mode MODE ?OPTIONS?     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
     qbox        Shorthand for "box --width 60 --quote"
     quote       Escape answers as for SQL
     table       ASCII-art table
     tabs        Tab-separated values
     tcl         TCL list elements
   OPTIONS: (for columnar modes or insert mode):
     --wrap N       Wrap output lines to no longer than N characters
     --wordwrap B   Wrap or not at word boundaries per B (on/off)
     --ww           Shorthand for "--wordwrap 1"
     --quote        Quote output text as SQL literals
     --noquote      Do not quote output text
     TABLE          The name of SQL table used for "insert" mode