Re: [ubuntu-uk] Visual Query Designer
2009/1/20 Guy Thouret > You might want to take a look at MySQL Workbench. I have found it the > best program I have come across for generating E-R diagrams of your > databases and creating MySQL table schemas in that you can then export as > SQL structures. > > As just a query designer, however, it may not be suitable. But for anyone > who regularly has to design and document MySQL databases it is well worth a > look. > http://dev.mysql.com/downloads/gui-tools/5.0.html > > There is also a version in the Ubuntu repositories. > > Guy. > > -- > ubuntu-uk@lists.ubuntu.com > https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk > https://wiki.ubuntu.com/UKTeam/ > > Guy, Thanks for the suggestion. It looks useful for the designing of databases, and I'll keep it install for this purpose, but it doesn't have the ability (as far as I can tell) to help me with designing queries for an already existing database. -- Steve Garton sheepeatingtaz.co.uk -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
Re: [ubuntu-uk] Visual Query Designer
2009/1/20 Oliver Marks > On Tue, 2009-01-20 at 13:44 +, Stephen Garton wrote: > > Afternoon All, > > > > I'm after a gui tool to help me design database queries (primarily for > > MySQL databases). > > > > In the windows world, I can use SQLyog enterprise - > > http://webyog.com/en/sqlyog_feature_list.php - (which works under > > wine) or even MS Access > > > > I have also tried Navicat - http://mysql.navicat.com/download.html - > > which essentially runs under wine as well. > > > > Anyone know of any Native tools for Linux that can do drag & drop > > query building? > > > > mysql query browser is in synaptic and the official tool on the mysql > website you can drag and drop table names and field names into your > querys to get actions to perform like join for example. > > -- > ubuntu-uk@lists.ubuntu.com > https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk > https://wiki.ubuntu.com/UKTeam/ > > Thanks Oliver, I was aware of the program, but not the drag & drop capabilities of it, I will certainly give it another go. -- Steve Garton sheepeatingtaz.co.uk -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
Re: [ubuntu-uk] Visual Query Designer
You might want to take a look at MySQL Workbench. I have found it the best program I have come across for generating E-R diagrams of your databases and creating MySQL table schemas in that you can then export as SQL structures. As just a query designer, however, it may not be suitable. But for anyone who regularly has to design and document MySQL databases it is well worth a look. http://dev.mysql.com/downloads/gui-tools/5.0.html There is also a version in the Ubuntu repositories. Guy. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
Re: [ubuntu-uk] Visual Query Designer
you could try http://dev.mysql.com/downloads/workbench/5.1.html MySQL Workbench 5.0 - The DBDesigner 4 Successor MySQL Workbench 5.0 has been developed by the Developer Tools Team of Sun Microsystems, Database Group. The team is lead by fabFORCE.net founder and DBDesigner4 implementor Michael G. Zinner, aiming to offer an improved database tooling experience for all platforms. http://www.fabforce.net/dbdesigner4/ DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. azmodie -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
Re: [ubuntu-uk] Visual Query Designer
On Tue, 2009-01-20 at 13:44 +, Stephen Garton wrote: > Afternoon All, > > I'm after a gui tool to help me design database queries (primarily for > MySQL databases). > > In the windows world, I can use SQLyog enterprise - > http://webyog.com/en/sqlyog_feature_list.php - (which works under > wine) or even MS Access > > I have also tried Navicat - http://mysql.navicat.com/download.html - > which essentially runs under wine as well. > > Anyone know of any Native tools for Linux that can do drag & drop > query building? > mysql query browser is in synaptic and the official tool on the mysql website you can drag and drop table names and field names into your querys to get actions to perform like join for example. signature.asc Description: This is a digitally signed message part -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
[ubuntu-uk] Visual Query Designer
Afternoon All, I'm after a gui tool to help me design database queries (primarily for MySQL databases). In the windows world, I can use SQLyog enterprise - http://webyog.com/en/sqlyog_feature_list.php - (which works under wine) or even MS Access I have also tried Navicat - http://mysql.navicat.com/download.html - which essentially runs under wine as well. Anyone know of any Native tools for Linux that can do drag & drop query building? TIA, Steve Garton www.sheepeatingtaz.co.uk -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
