Execute SQLite script

user_365298 0
Viewed 137695

I start up sqlite3 version 3.7.7, unix 11.4.2 using this command:

sqlite3 auction.db

where auction.db has not already been created.

sqlite> auction.db < create.sql;

gives me this error: near "auction": syntax error

How can I run the script?

sqlite
6 Answers

For those using PowerShell

PS C:\> Get-Content create.sql -Raw | sqlite3 auction.db
user_24212770

If you are using the windows CMD you can use this command to create a database using sqlite3

C:\sqlite3.exe DBNAME.db ".read DBSCRIPT.sql"

If you haven't a database with that name sqlite3 will create one, and if you already have one, it will run it anyways but with the "TABLENAME already exists" error, I think you can also use this command to change an already existing database (but im not sure)

user_136936050 
sqlite3 -init create.sql auction.db .quit

When I enter the command man sqlite3, I see under "OPTIONS":

-init file
       Read and execute commands from file , which can contain a mix of SQL statements and meta-commands.

and under "SQLITE META-COMMANDS":

.quit                    Exit this program

See also: Command Line Shell For SQLite: 3. Special commands to sqlite3 (dot-commands).

Also, when I enter the command sqlite3 -help, I see under "OPTIONS":

-init FILENAME       read/process named file

user_2429330
Related