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