Re: [sqlite] Sqlite3: create a database from file using one line command-line script

2019-02-06 Thread Keith Medcalf
sqlite3 database.db < myscript.sql --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of kostasvgt >Sent: Wedne

Re: [sqlite] Sqlite3: create a database from file using one line command-line script

2019-02-06 Thread Donald Griggs
sqlite3 myDatabase.db ".read myCommands.sql" On Wed, Feb 6, 2019 at 3:30 PM kostasvgt wrote: > Hi, I need to run a command to create a database and populate it from a > .sql file at once from command-line, not dot-commands. > Is there any way to do this in one line? > > Thanks. >