[thelist] MySQL GUI Interfaces

[Hans Zaunere]

Well phpMyAdmin
(http://www.phpwizard.net/projects/phpMyAdmin/) of
course!

I use it from one web server to handle over 6 MySQL
servers, all about different versions.  Have hit it
with queries that result in over 100,000 rows and it
didn't flinch.  Excellent product.

Also, MySQL lists some GUIs at
http://mysql.com/downloads/gui-clients.html (I've used
MyCC which isn't too bad.)

And then there's always
http://www.google.com/search?hl=en&q=mysql+gui.

But really, go with phpmyadmin.


Hans Zaunere
New York PHP
http://nyphp.org


--- Jay Blanchard
<jay.blanchard at niicommunications.com> wrote:
> G'mornin' group,
>
> Currently I am using MySQLGUI 1.7.5-1 on my Linux
> box, and while it is a
> timesaver I am in need of more power and
> flexibility. Knowing that you all
> would know what works I seek your input (gawd, I am
> formal this morning!
> :-) ). I have looked at many MySQL GUI's, I just
> need some recommendations
> during this time of me not having much time to test
> and pick a new
> interface.
>
> I need a GUI with the following features -
> * Can be either Linux based or Windows based.
> * Must be able to connect easily to multiple MySQL
> databases on multiple
> servers without having to change an 'options'
> setting.
> (similar to MS SQL Server Enterprise Manager)
> * Must have the ability to run lengthy SQL scripts
> without choking (MySQLGUI
> will not). I know that I can do this from the
> command line, which I do
> frequently, but if the GUI has syntax checking it
> would help vastly, you
> know how frustrating a syntax error can be to track
> down.
> * If it has an easy to manage GRANTS feature that
> would be a big plus.
>
> Thanks all for your input!
>
> Jay
>
> <tip type="MySQL & PHP" author="Jay Blanchard">
> When needing to return/print a SUM or a COUNT from a
> SQL query in PHP you
> have to give PHP a handle to grab the SUM or COUNT
> information so that it
> can be displayed or used;
>
> WRONG! :(
> SELECT COUNT(*)
> FROM tblFoo
> Does not give PHP a handle to the COUNT
>
> RIGHT! :)
> SELECT COUNT(*) AS CountOfFoo
> FROM tblFoo
> Now you can print("$row->CountOfFoo") or work with
> CountOfFoo as you need.
>
> Another example;
> SELECT SUM(TotalSales) as SalesTTL
> FROM tblFoo
> SalesTTL is the handle that PHP can work with.
>
> A NOTE OF CAUTION! - Do not name the handle the same
> as a column name with
> which you are working, the result is not pretty.
> Always give the handle a
> unique name.
> </tip>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/