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

Hello Max,
thanks for that,

If I understand what you have said correctly, he would have to install
dreamweaver - did I get that right ?

I am currently considering installing an ODBC and allowing him to build
queries through linked tables in MS Access, then once he has built the
table, I will show him how to copy the SQL and drop it into a pass-through
query.  For queries that he uses more than once, I will show him how to
either create an sproc or a view depending on whether there are criteria to
be supplied.

Anyone any thoughts on that?

On a further note for anyone else reading this thread, on further review (an
additional five minutes), I noticed that EnginSite does have a diagram model
for building multi-table queries, so that would be an option for someone
that does not have Access, however, in my case, I think Access will be good
enough.

Thanks to all for your responses.

Mark



2009/10/22 Max Wanadoo <max.wanadoo at gmail.com>

> Mark,
>
> My friend gave me this answer - hope it helps
>
>
> I use the dreamweaver developer toolkit QUB it works exactly like access
> query's but it's web based and you need both dreamweaver and the developer
> toolkit to upload the files logon to the mysql  then  run a query. I've
> never found one better
>
>
>
>
>
> Max
>
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen
> Sent: 22 October 2009 18:54
> 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
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>