If I'm going to do that, it seems easier to just add a .width line to
my .sqliterc file that specifies a larger width for about 10 or so
columns. Still not perfect though.
On 8/29/06, Fred Williams <[EMAIL PROTECTED]> wrote:
From experience. Most "free form" output routines I have used utiliz
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
>From experience. Most "free form" output routines I have used utilizes
the content of the first row to establish the width of "columns." (i.e.
Reflected in the result per your "Administrative Assistant")
If you can "throw away" your first row of output, you could insert a
first row in your table
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
6 matches
Mail list logo
