Mark Breen
marklbreen at gmail.com
Thu Oct 22 12:53:30 CDT 2009
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