is redirection so hard? sqlite3 database.db < database.commands
On Sun, Aug 27, 2017 at 10:31 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 28 Aug 2017, at 6:25am, Csányi Pál <csanyi...@gmail.com> wrote: > > > Probe.db is a list of SQL commands, stored as a text file, and not a > > SQLite database. > > Then please do not use a name for this file ending in ".db". It is not a > database. It is a list of commands. I suggest a name ending in ".txt" or > ".sql". > > > How can I get it in SQLite database, instead of just a text file with > > SQL commands? > > You start the sqlite3.exe program using the command > > sqlite3 Probe.db > > Once you have the "sqlite>" prompt, type those commands one by one. Or > you can instead use the ".read Probe.txt" command to process all commands > in the file. When you are finished use the ".quit" command to exit the > shell tool. > > Then look on your disk for the "Probe.db" file and it will the database > file. > > Simon. > _______________________________________________ > 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
