Mercurial > getan
comparison README @ 92:565825db59d2
Use ".read" instead of ".r" in sqlite3 command
".r" is ambiguous and sqlite 3.6.11 added ".restore"
| author | Thomas Arendsen Hein <thomas@intevation.de> |
|---|---|
| date | Wed, 17 Aug 2011 12:48:39 +0200 |
| parents | 9c4e8ba3c4fa |
| children | 13a963546ee9 |
comparison
equal
deleted
inserted
replaced
| 91:40f52b4b02a4 | 92:565825db59d2 |
|---|---|
| 12 To create an empty database you need the 'sqlite3' | 12 To create an empty database you need the 'sqlite3' |
| 13 commandline tool. TODO: This will change. | 13 commandline tool. TODO: This will change. |
| 14 | 14 |
| 15 # apt-get install sqlite3 | 15 # apt-get install sqlite3 |
| 16 | 16 |
| 17 $ echo '.r schema.sql' | sqlite3 time.db | 17 $ echo '.read schema.sql' | sqlite3 time.db |
| 18 | 18 |
| 19 2 - adding new projects to time.db: | 19 2 - adding new projects to time.db: |
| 20 | 20 |
| 21 $ sqlite3 time.db | 21 $ sqlite3 time.db |
| 22 sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); | 22 sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); |