There is the .read function which will read in a file that contains insert 
statements. This is done through the shell.

~Kirk
-----Original Message-----
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of john knops
Sent: Tuesday, August 03, 2010 6:53 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Populating a database from a file

If I'm using MySQL I can populate a database with "Load data infile 
'/tmp/data.txt' into table table_1"
Is there a similar way of loading data into a sqlite3 database?

Thanks............



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to