On 1/30/06, Clint Bailey <[EMAIL PROTECTED]> wrote: > Is it possible to import tab delimited data into sqlite in order to > start testing? You can use sqlite3 command for that. Something like this:
E:\SQLite>sqlite3.exe test.db3 SQLite version 3.2.6 Enter ".help" for instructions sqlite> CREATE TABLE test(a, b, c, d); sqlite> .mode tabs sqlite> .import "tab_delimited_data.txt" test sqlite> .mode column sqlite> SELECT * FROM test LIMIT 10; Of course, replace "test" table above with something that matches number of columns in your input file. There's a patch attached to http://www.sqlite.org/cvstrac/tktview?tn=1506 that adds 2 flags to .import. If you are on windows I can send you sqlite3.exe compiled with that patch if you need it. -- Nemanja Corlija <[EMAIL PROTECTED]>
