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

送时间： 2009-05-04 11:16:35 收件人： General Discussion of SQLite Database 抄送： 主题： 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 comma

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

tp://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

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