[thelist] MySQL GUI Interfaces

[Jay Blanchard]

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>