Execute SQL statements from a file

gistfile1.txt

Execute SQL statements from a file


Suppose we have a file named commands.txtin the c:\sqlite\folder with the following content:

```
SELECT albumid, title
FROM albums
ORDER BY title
LIMIT 10;
Code language: Shell Session (shell)
```

To execute the SQL statements in the commands.txtfile, you use the .read FILENAMEcommand as follows:

```
sqlite> .mode column
sqlite> .header on
sqlite> .read c:/sqlite/commands.txt
AlbumId     Title
----------  ----------------------
156         ...And Justice For All
257         20th Century Masters -
296         A Copland Celebration,
94          A Matter of Life and D
95          A Real Dead One
96          A Real Live One
285         A Soprano Inspired
139         A TempestadeTempestade
203         A-Sides
160         Ace Of Spades
Code language: Shell Session (shell)
```