Please disregard my last email - I was loading an incorrect copy of the database into SQLite Administrator.
On Tue, Nov 12, 2013 at 2:42 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > -- Shaun Thomson Owner - SongbookDB _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users