Windows 7, DOS command line.  It works, thanks.

From: sqlite-users on behalf of Simon Slavin
Sent: Friday, March 22, 2019 11:15 AM
To: SQLite mailing list
Subject: Re: [sqlite] cmd line question on import

On 22 Mar 2019, at 3:06pm, Jose Isaias Cabrera <jic...@outlook.com> wrote:

> I have a db in c:\temp\sqliteDB.sqlite3 which has the Project_List table. I 
> can use,
>
> sqlite3 "c:\temp\sqliteDB.sqlite3"
>
> and copy and paste the content of the file, and it works fine. But I am 
> trying to do this from the command line.  Something like,
>
> sqlite3 "c:\temp\sqliteDB.sqlite3" -i c:\temp\import.sql

The answer depends on the shell you're using.  You do not tell us what 
operating system or which shell you're using.  However, the answer is likely to 
be something like

sqlite3 "c:\temp\sqliteDB.sqlite3" < c:\temp\import.sql
_______________________________________________
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

Reply via email to