[dba-VB] Can anyone suggest a Windows good client for mySQL

Jim Lawrence accessd at shaw.ca
Thu Oct 22 13:53:31 CDT 2009


Hi Mark:

If you are setting up MySQL you should start thinking of using SPs. MySQL
version 5 has this feature and pass-through queries in MSAccess, especially
SELECT type queries are soooo slowwwwww.

Check out the following:

http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html

HTH
Jim 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen
Sent: Thursday, October 22, 2009 10:54 AM
To: Discussion of Hardware and Software issues; Discussion concerning Visual
Basic and related programming issues.
Subject: [dba-VB] Can anyone suggest a Windows good client for mySQL

Hello All,
I have to assist a friend tomorrow in connecting to a mySQL database and
starting to build some queries.

I intend to show him the differences between writing queries in MS Access
when linked to mySQL, and using pass-through queries within Access.

I will also be explaining the benefits of having a few views created also.

What I am looking for is a Windows based GUI tool that would connect to
mySQL and allow him to build queries with click and drag like SSMS or Access
does.

This evening I have downloaded and installed two tools, one is the default
GUI as shipped by mySQL and another is named EnginSite.  Both seem, on
initial looking anyway, to to allow me to drag a few fields from a table,
but they do not seems to allow me to drag two or three tables and for the
joins to be done in the GUI.

Would anyone have any suggestions?

TIA for your time,

Mark
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




More information about the dba-VB mailing list