Hi, I am interested in this issue also. I didn't understand the first part of your answer. "sqlite3 databasefile < infile" ??
The ".import FILE TABLE" works, but it is from CLI. How can I do it in my C++ application using the sqlite3? Thanks Filipe Madureira Alexandre Courbot wrote: >> I usually used "load data infile" command in mysql to insert long list of >> data. >> But I could not find this kind of command in sqlite. >> How do you load big file into a sqlite database?? >> > > I guess what you want to do is "sqlite3 databasefile < infile" > > See also the ".import FILE TABLE" command to inport a file into a single > table. > > Alex. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users