Re: [sqlite] How can I load big file into a sqlite database?

That's what I do. I was looking for a kind of pre-built solution that could have better performance in loading a table than to do a INSERT for each line inside a transaction. But thanks Filipe Madureira Alexandre Courbot wrote: >> I am interested in this issue also. >> I didn't understand

Re: [sqlite] How can I load big file into a sqlite database?

> 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? An equivalent would be to read the file line by line

Re: [sqlite] How can I load big file into a sqlite database?

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

Re: [sqlite] How can I load big file into a sqlite database?

Thanks Alex, "import FILE TABLE" is exactly what I'd like to do ^^ Junghyun> Date: Fri, 29 Aug 2008 00:39:03 +0900> From: [EMAIL PROTECTED]> To: sqlite-users@sqlite.org> Subject: Re: [sqlite] How can I load big file into a sqlite database?> > > I usually

Re: [sqlite] How can I load big file into a sqlite database?

> 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

[sqlite] How can I load big file into a sqlite database?

Hi all, 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?? Thanks for your future help~!