Re: [sqlite] Populating a database from a file

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

Re: [sqlite] Populating a database from a file

On 3 August 2010 14:52, john knops wrote: > 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 > >From sqlite shell use '.import' http://www.sqlite.org/