Jack Lee writes:
> Thanks a lot for reading my question :))
> Later, I found I just solve the problem by
> end the connads with an annoying ";".
>
> Also, I find the content of the tables
> is too long to display in one screen. It
> messes up the screen with the wrapping.
> Would you suggest some nice program to
> adjust the display? or some x-program to
> display with a scroll-bar?
>
> BTW, I read the manual which comes within
> the debian mysql packages. It's a really
> well-explanatory, detailed doc. But, I
> don't find it specifies every command must
> end with a ";" .
> I think this is just one of those things,
> which is too small for experienced users to
> mention and emphize, but too much for newbies
> like me to notify. :)
>
>
> Sincerely
>
>
> Jack
>
>
>
>
> >From: "Ricardo T. Saito" <rtsaito@stripped>
> >To: "Jack Lee" <lchihsun@stripped>, <mysql@stripped>
> >Subject: Re: [SQL] a newbie's question on language syntax
> >Date: Thu, 26 Aug 1999 15:44:56 -0300
> >
> >You have to type "\g" or ";" after each command.
> >
> >select * from mysql ;
> >or
> >select * from mysql \g
> >
> >To show the databases:
> >show databases;
> >
> >To see the contents of the database mysql use :
> >show tables from database_name;
> >
> >Maybe you should read the manual. :-)
> >Ricardo.
> >
> >-
> >Ricardo T. Saito (rtsaito@stripped)
> >UNICAMP - Engenharia de Computacao 94
> >DGLNet - Departamento de Tecnologia da Informacao
> >http://www.dcc.unicamp.br/~rtsaito
> >
> >-----Mensagem Original-----
> >De: Jack Lee <lchihsun@stripped>
> >Para: <mysql@stripped>
> >Enviada em: Quinta-feira, 26 de Agosto de 1999 15:38
> >Assunto: [SQL] a newbie's question on language syntax
> >
> >
> > > Hi:
> > >
> > > Thanks for reading my problem. I got MySQL
> > > installed a while ago. My problem is how to
> > > display database(or table) content with
> > > proper syntax of SQL language.
> > >
> > > The following is a quote from the interactive
> > > mode of MySQL, under which I've tried several
> > > commands. The database I was working on is named
> > > "mysql":
> > >
> > >
> > > mysql->select *
> > > ->SELECT *
> > > ->select * from mysql
> > > ->SELECT * FROM mysql
> > >
> > >
> > > My purpose was just to look at the content of
> > > the database, "mysql". There showed nothing, no
> > > matter how I tried using "select" or "show". BTW,
> > > I'm just wondering does commands have to be small
> > > latters or big letters?
> >
> >
>
HI!
Try mysqlgui client, aka sqlclient, found on
www.mysql.com/download_client(s).html.
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
