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 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'); sqlite> select * from t; Secretary Programmer Programmer II sqlite> On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote: > 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 > ---------- > Administrative Assistant > Programmer > Programmer II > > So why didn't it expand for Programmer II, but it does expand for AA? > > Thanks, > John > > > > > > > On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote: > > 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/06, John Salerno <[EMAIL PROTECTED]> wrote: > > > Is it possible to change the width of columns in column mode in some > > > general way? What I mean is, I know I can do .width X X X etc., but > > > that requires knowing how many columns you have. Is there some way to > > > set it so that the column will simply expand to fit the information? > > > > > > Second, I created a row entry like this: > > > > > > salary double(6, 2) > > > > > > and then entered a number such as 45000.00, but the output shows it as 45000.0 > > > > > > Maybe this comes from ignorance of how SQL works in general, but > > > shouldn't it show the second 0, since I typed it that way and I > > > declared the field to have 2 decimal places? > > > > > > Thanks, > > > John > > > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------