don't forget to wrap inserts in begin; commit; pairs
On 6/17/08, Dennis Cote <[EMAIL PROTECTED]> wrote: > Alberto Simões wrote: > > > > I have a text file with 18 399 392 lines. Each line contains five > > fields. Four are a compound key, the other is just data. > > What is the best way to import this to sqlite? > > > > I am thinking on creating another text file with 18 399 392 INSERT > > commands. > > Would that be the best method? > > > > You might be able to do it more directly using the .import command. It > can read a fixed number of columns separated by fixed delimiters. It > works with CSV files for example. > > All data are inserted as strings, but the strings may be converted to > integer or real values if the columns have suitable affinity (see > http://www.sqlite.org/datatype3.html for more details). > > HTH > Dennis Cote > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users