Re: [sqlite] How to create a table from a text file via c/c++interface?

It works. I changed " for (int i=0;i<1e5;i++) { rc = sqlite3_exec(db, "insert into wigfile values(1,2000,3000,0.4)", callback, 0, ); }" into "sqlite3_exec(db, "begin", callback, 0, ); for (int i=0;i<1e5;i++){ rc = sqlite3_exec(db, "insert into wigfile values(1,2000,3000,0.4)", callback,

Re: [sqlite] How to create a table from a text file via c/c++ interface?

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

[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"