> 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