[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~!
 
 
 
_
Invite your mail contacts to join your friends list with Windows Live Spaces. 
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 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 a file into a single table.  Alex. 
___ sqlite-users mailing list 
sqlite-users@sqlite.org 
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+worldmkt=en-USform=QBRE
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users