sqlite3 is chopping/cutting/truncating my text columns

sql sqlite truncate
Dan picture Dan · Nov 17, 2009 · Viewed 12.3k times · Source

I have values being cut off and would like to display the full values.

Sqlite3 -column -header locations.dbs "
select n.namelist, f.state, t.state
from names n
left join locations l on l.id = n.id
left join statenames f on f.st = l.st
left join statenames t on t.st = l.stto
where n.timing > 200601 and count(n.timing)<=15"

Which gives me

name        From State   To State  
----------  -----------  ----------
Jack        Connecticut  Louisiana 
Jeff Danie  New Hampshi  New Hampsh

The names are being truncated down to 10 characters or the length of the first row of data, whichever is longer. How can I stop this from happening without making the columns larger than they have to be?

Thanks

Answer

Blorgbeard picture Blorgbeard · Nov 17, 2009

There doesn't appear to be a way to make it automatic, but you can use the .width command to manually specify the column widths.

See here (search the section for .width).

Related questions

Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More
Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); However, I am getting an error when …

Read More