On 26-12-2018 08:20, Clemens Ladisch wrote:
Luuk wrote:
sqlite> .mode column
sqlite> .headers on
sqlite> select 1 as X,date() as d union all select 2,date() union all
select 3,datetime();
X d
---------- ----------
1 2018-12-25
2 2018-12-25
3 2018-12-25
The value is longer than the column with (which is probably based on the
values in the first line).
Try ".width 10 20".
A, now i know why i do not use 'mode column'....
It's too much typing work to find out how wide the columns are.
'.mode tabs' seems to fit my need more.
Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users