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?

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 and execute

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 the

[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~! _

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 to inport

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 used load data infile command in mysql