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: [email protected] [mailto:[email protected]] On Behalf Of john knops Sent: Tuesday, August 03, 2010 6:53 AM To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
