Re: [sqlite] Sqlite3: create a database from file using one line command-line script
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: Wednesday, 6 February, 2019 12:47 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Sqlite3: create a database from file using one line >command-line script > >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. >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3: create a database from file using one line command-line script
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. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite3: create a database from file using one line command-line script
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. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users