Well I've tried the following
sqlite3 <path to the DB> dbfile
I get put to the command line.
typed in the following and below is the results.
sqlite> .show
echo: off
explain: on
headers: on
mode: explain
nullvalue: ""
output: stdout
separator: "|"
width: 4 13 4 4 4 13 2 13
sqlite> .schema ?table? accounts;
sqlite> .schema ?accounts?;
sqlite>
So I don't know if it's me not understanding the syntax or not.
I have 5 tables one of them *is* accounts.
thanks for your reply.
2009/12/7 Wilson, Ronald <rwils...@harris.com>
> what tables do you have?
> sqlite> schema;
>
> from my mobile 434.851.1612
>
> On Dec 5, 2009, at 11:31 PM, "dave lilley" <dgl...@gmail.com> wrote:
>
> >
> > I have been trying to (without much joy) get a list of rows from a
> > table
> > within an sqlite3 DB.
> >
> > I've been starting from the CMD prompt sqite3 <DB filename here>
> > dropping into sqlite3 cmd prompt i type in....
> >
> > sqlite> select * from accounts;
> > SQL error: no such table: accounts
> > sqlite>
> >
> > Now I've used SQLite Database manager 3.1 to create the tables (at
> > least 5
> > in the one db) and have been able to access the tables until i
> > started to
> > entry text for a blob field and now the DB manager falls over!
> >
> > I am using ruby 1.8.6 as my dev language an suppose i should put it
> > to that
> > community BUT my issue of not being able to generate a list of data
> > from an
> > sql statement when i know the names of the tables does belong here.
> >
> > any help would be appreciated.
> >
> > dave.
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
