Hi, Feng, I don't think that "load data from" is part of the sql standard -- I may be wrong.
At any rate, the source code to the command line utility is freely available. When you wrote that "Using ' insert into values' ... is very time comsuming" did you mean time consuming to write the program, or time-consuming to run? If it is taking a very long time to RUN compare to the sqlite3 ".import" command, then be sure you're surrounding the import (or at least every 1000 lines or so) in a TRANSACTION. Expect a large increase in speed. http://www.sqlite.org/lang_transaction.html Perhaps this helps, Donald Griggs -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of knightfeng Sent: Sunday, May 03, 2009 10:41 PM To: sqlite-users Subject: [sqlite] How to create a table from a text file via c/c++ interface? Hi, '.import' can be used to create a table from text file in the command line version , but how can I do that using C/C++ interface? Using ' insert into values' by reading a text file line by line is very time comsuming and it seems that there is no such SQL command "LOAD DATA FROM" supported by MySql in sqlite. Many thanks. Zhixing Feng 2009-05-04 knightfeng _______________________________________________ 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