;X"'s in all positions out to your maximum
column widths. Export the data and delete the first line.
Fred
> -Original Message-
> From: John Salerno [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 29, 2006 11:39 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Re:
On 8/29/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:
John Salerno wrote:
> So why didn't it expand for Programmer II, but it does expand for AA?
AIUI, the default column width is the greater of 10 and the width of the
first line of output.
Ah, thanks! I had even read about this, but I misund
11:39 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Re: two questions about formatting output
>
>
> Alright, one final note, because now I'm really confused. Here was my
> original row data:
>
> Secretary, Programmer, Programmer II
>
> It displayed like this:
John Salerno wrote:
So why didn't it expand for Programmer II, but it does expand for AA?
AIUI, the default column width is the greater of 10 and the width of the
first line of output.
sqlite> .mo co
sqlite> .he on
sqlite> create table t(t TEXT UNIQUE);
sqlite> insert into t(t) values("
But if you do .mode column (and .header on, if that matters), it outputs:
a
Secretary
Programmer
Programmer
John
On 8/29/06, P Kishor <[EMAIL PROTECTED]> wrote:
>"C:\Program Files\sqlite3" tmp.db
SQLite version 3.3.7
Enter ".help" for instructions
sqlite> create table t (a
"C:\Program Files\sqlite3" tmp.db
SQLite version 3.3.7
Enter ".help" for instructions
sqlite> create table t (a text);
sqlite> .s
CREATE TABLE t (a text);
sqlite> insert into t values ('Secretary');
sqlite> insert into t values ('Programmer');
sqlite> insert into t values ('Programmer II');
sqlit
Alright, one final note, because now I'm really confused. Here was my
original row data:
Secretary, Programmer, Programmer II
It displayed like this:
title
--
Secretary
Programmer
Programmer
I changed Secretary to Administrative Assistant and now it shows like this:
title
--
A
Just as a follow-up, I noticed that one of my columns *did* expand to
fit a longer name, yet another column didn't. Could it be because the
one that expanded contained a string of a single word, while the
column that didn't expand contained multiple words, i.e. 'Programmer
II'?
Thanks.
On 8/29
8 matches
Mail list logo
