Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

2019-10-03 Thread Richard Damon
On 10/3/19 5:46 AM, 算 子 wrote: > In column mode, each record is shown on a separate line with the data aligned > in columns. For example: > > sqlite> .mode column > sqlite> select * from tbl1; > one two > -- -- > hello 10 > goodbye 20 >

Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

2019-10-03 Thread Kees Nuyt
On Thu, 3 Oct 2019 09:46:27 +, suan...@outlook.com wrote: > In column mode, each record is shown on a separate > line with the data aligned in columns. For example: > sqlite> .mode column > sqlite> select * from tbl1; > one two > -- -- > hello 10

[sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

2019-10-03 Thread 算 子
In column mode, each record is shown on a separate line with the data aligned in columns. For example: sqlite> .mode column sqlite> select * from tbl1; one two -- -- hello 10 goodbye 20 sqlite> But I found,only when columns text is