[thelist] MySQL GUI Interfaces

Peter Loron peterl at cnw.com
Tue Mar 26 10:50:14 CST 2002


I've been quite happy using phpMyAdmin on the web and MySQLFront on
Windows.

http://www.mysqlfront.de/

-Pete
On Tuesday, March 26, 2002, at 06:03  AM, Jay Blanchard 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 !




More information about the thelist mailing list