By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,934 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,934 IT Pros & Developers. It's quick & easy.

Performing a SQL statement

P: n/a
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?
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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
Jul 20 '05 #2

P: n/a
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
---------------------------------------------------------------
Jul 20 '05 #3

P: n/a
"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

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.