Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. I can load and search the db now.
So to drop the index 'index1' for the table 'table1', do I just type DROP INDEX IF EXISTS 'index1'; ? Doing so still shows the index when I load the database in 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