How to execute an sql script file against an SQLite 3 database file?

Question

What is an SQLite 3 (3.7.11) analogue of MySQL's

mysql -p -u username database_name < file.sql

to execute all the queries in a given SQL script file against a specified database?

user610650 · Accepted Answer · 2012-04-06 14:54:43Z

66

This should work:

[someone@somewhere ~]$ echo "select * from sometable;" > file.sql
[someone@somewhere ~]$ sqlite3 file.db < file.sql 
10/02/2012
11/01/2012
09/03/2012

answered Apr 6, 2012 at 14:54

user610650

Sign up to request clarification or add additional context in comments.

1 Comment

Almost exactly the same as in MySQL. Thanks.

Jacek Siciarek · Accepted Answer · 2016-01-06 08:48:30Z

6

The following should work as well:

 echo "SELECT id, username, email FROM fos_user_user;" | sqlite3 app/data.db3

answered Jan 6, 2016 at 8:48

Jacek Siciarek

921 silver badge1 bronze badge

This is not related to question