On 2015-04-10 04:11 PM, Richard Hipp wrote: > https://www.sqlite.org/toc.db
I download this and do the following: 164:~ simon$ sqlite3 /Users/simon/Desktop/toc.db SQLite version 3.8.5 2014-08-15 22:37:57 Enter ".help" for usage hints. sqlite> .mode column sqlite> select * from toc limit 10; sqlite3 object 0 Database Connection Handle c3ref/sqlite3.html sqlite3_in object 0 64-Bit Integer Types c3ref/int64.html sqlite3_ui object 0 64-Bit Integer Types c3ref/int64.html sqlite_int object 0 64-Bit Integer Types c3ref/int64.html sqlite_uin object 0 64-Bit Integer Types c3ref/int64.html sqlite3_fi object 0 OS Interface Open File Han c3ref/file.html sqlite3_io object 0 OS Interface File Virtual c3ref/io_methods.h sqlite3_mu object 0 Mutex Handle c3ref/mutex.html sqlite3_vf object 0 OS Interface Object c3ref/vfs.html sqlite3_me object 0 Memory Allocation Routines c3ref/mem_methods. I know that the .width command exists, but why is the first column so short ? Is the shell tool set to use width 10 for the first column ? All the columns except for the numeric one are defined as TEXT but they're given different widths. Simon.
