Execute SQLite script

Question

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 gt  auction db  lt  create sql    gives me this error  near  auction   syntax error  How can I run the script

User · Answer

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 · Answer

You want to feed the create sql into sqlite3 from the shell  not from inside SQLite itself     sqlite3 auction db  lt  create sql   SQLite s version of SQL doesn t understand  lt  for files  your shell does

User · Answer

In order to execute simple queries and return to my shell script  I think this works well     sqlite3 example db  SELECT   FROM some table

User · Answer

For those using PowerShell  PS C   gt  Get-Content create sql -Raw   sqlite3 auction db

User · Answer

There are many ways to do this  one way is   sqlite3 auction db  Followed by   sqlite gt   read create sql  In general  the SQLite project has really fantastic documentation  I know we often reach for Google before the docs  but in SQLite s case  the docs really are technical writing at its best  It s clean  clear  and concise

[sqlite] Execute SQLite script

Examples related to sqlite