[thelist] MySQL GUI Interfaces

[Dan Romanchik]

Check out PHPMyAdmin at http://www.phpwizard.net/projects/phpMyAdmin/. It's
web-based, so it's really good for administering MySQL databases on shared,
remote servers, which is how I use it, but it may work for you as well.

Dan
----------------------------------------------------------------------------
Dan Romanchik - Writer, Editor,  and Web Developer
dan at danromanchik.com, 734-930-6564



----- Original Message -----
From: "Jay Blanchard" <jay.blanchard at niicommunications.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, March 26, 2002 9:03 AM
Subject: [thelist] MySQL GUI Interfaces


> 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 !
>