Performing a SQL statement

[Bernie Yeater]

I am used to I_SQL in SQL SERVER and SQL Plus in Oracle, I can not
find anything in MySQL that is simlar for building a querry.

Is there a client side tool that is simular?

[Thomas Bartkus]

"Bernie Yeater" <be**********@msn.com> wrote in message
news:e8**************************@posting.google.c om...

I am used to I_SQL in SQL SERVER and SQL Plus in Oracle, I can not
find anything in MySQL that is simlar for building a querry.

Is there a client side tool that is simular?

Are you talking about a GUI tool - to let you diagram your query and then
generate the SQL for you? I have found nothing better than MS Access.

Since you can create tables linked to your MySQL database inside MS Access,
that is the tool I would recommend. I have found this to be a great way to
learn the SQL language also.

If someone knows of a better GUI client for doing this, Windows or Linux, I
would love to hear about it myself.

Thomas Bartkus

[Jeff North]

On Tue, 1 Jun 2004 17:10:48 -0500, in mailing.database.mysql "Thomas
Bartkus" <Th***********@Comcast.net> wrote:

| "Bernie Yeater" <be**********@msn.com> wrote in message
| news:e8**************************@posting.google.c om...
| > I am used to I_SQL in SQL SERVER and SQL Plus in Oracle, I can not
| > find anything in MySQL that is simlar for building a querry.
| >
| > Is there a client side tool that is simular?
|
| Are you talking about a GUI tool - to let you diagram your query and then
| generate the SQL for you? I have found nothing better than MS Access.
|
| Since you can create tables linked to your MySQL database inside MS Access,
| that is the tool I would recommend. I have found this to be a great way to
| learn the SQL language also.
|
| If someone knows of a better GUI client for doing this, Windows or Linux, I
| would love to hear about it myself.

I agree with you wholeheartedly but remember there are a lot of
idiosyncrasies with Access i.e. square brackets around fieldnames with
spaces, use of double quotes, various functions that are not
available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Thomas Bartkus]

"Jeff North" <jn****@yourpantsbigpond.net.au> wrote in message
news:ms********************************@4ax.com...

I agree with you wholeheartedly but remember there are a lot of
idiosyncrasies with Access i.e. square brackets around fieldnames with
spaces, use of double quotes, various functions that are not
available.

How can I forget about Access idiosyncrasies :-)

Nevertheless, it has it's charms. And when you speak of "various function
that are not available" - I must point to the ability to write ones own
aggregate functions directly into Access via VBA. At this point (new to
MySQL & Linux!) I am praying I can do something similar with MySQL.

Thomas Bartkus