On 12 Nov 2013, at 2:49am, SongbookDB <shaun_thom...@songbookdb.com> wrote:

> I've named it db.s3db, run the shell, type sqlite3 db, then select * from
> songs; and it gives the error "Error: near "sqlite3": syntax error.

as a command to your operating system

sqlite3 db.s3db

then once you're in the program type SQL commands or things like

.schema
SELECT * FROM sqlite_master;
DROP INDEX fred;
SELECT * FROM sqlite_master;
.quit

.quit to exit.  For further information

<http://www.sqlite.org/sqlite.html>

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to