Is there a good user interface to mysql?

[James Johnson]

I'm looking for something that would let me scroll through tables and
edit rows and columns graphically in windows. Does anyone know of such a
program?

Jim

[Thomas Bartkus]

"James Johnson" <[e-mail]> wrote in message
news:66********************************@4ax.com...

I'm looking for something that would let me scroll through tables and
edit rows and columns graphically in windows. Does anyone know of such a
program?

Are you doing this from an MS Windows workstation?
I know of nothing better for this than MS Access. Even if you *never* work
with MS Access databases, using it as a front end to MySQL (or Oracle, or
PostGres, or SQL server) will make you happy.

Are you doing this from a Linux (GUI) Workstation?
The closest equivalent I know of is a product called Rekall. Sorry I
haven't tried it.

Thomas Bartkus

[Chris Hope]

James Johnson wrote:

I'm looking for something that would let me scroll through tables and
edit rows and columns graphically in windows. Does anyone know of such
a program?

MySQL Control Center (developed by MySQL) which unfortunately they have
stopped development on. However, it is a very useful tool.
http://dev.mysql.com/downloads/other/mysqlcc.html

There's also the MySQL Query Browser which works a lot like the MSSQL
version: http://dev.mysql.com/downloads/query-browser/1.1.html

And finally MySQL Administrator which is for admining databases:
http://dev.mysql.com/downloads/administrator/1.0.html

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[James Johnson]

On Mon, 27 Dec 2004 16:21:53 -0600, "Thomas Bartkus" <to*@dtsam.com>
wrote:

"James Johnson" <[e-mail]> wrote in message
news:66********************************@4ax.com.. .

I'm looking for something that would let me scroll through tables and
edit rows and columns graphically in windows. Does anyone know of such a
program?

Are you doing this from an MS Windows workstation?
I know of nothing better for this than MS Access. Even if you *never* work
with MS Access databases, using it as a front end to MySQL (or Oracle, or
PostGres, or SQL server) will make you happy.

Are you doing this from a Linux (GUI) Workstation?
The closest equivalent I know of is a product called Rekall. Sorry I
haven't tried it.

Thomas Bartkus

Yes, I'm doing this from windows. I had no idea that access could talk
to mysql. Do you know where I can find out how to do this?

Jim

[Chris Hope]

James Johnson wrote:

On Mon, 27 Dec 2004 16:21:53 -0600, "Thomas Bartkus" <to*@dtsam.com>
wrote:

"James Johnson" <[e-mail]> wrote in message
news:66********************************@4ax.com. ..

I'm looking for something that would let me scroll through tables
and edit rows and columns graphically in windows. Does anyone know
of such a program?

Are you doing this from an MS Windows workstation?
I know of nothing better for this than MS Access. Even if you *never*
work with MS Access databases, using it as a front end to MySQL (or
Oracle, or
PostGres, or SQL server) will make you happy.

Are you doing this from a Linux (GUI) Workstation?
The closest equivalent I know of is a product called Rekall. Sorry I
haven't tried it.

Thomas Bartkus

Yes, I'm doing this from windows. I had no idea that access could talk
to mysql. Do you know where I can find out how to do this?

There's an ODBC driver at http://www.mysql.com/products/connector/odbc/

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Thomas Bartkus]

On Mon, 27 Dec 2004 21:12:56 -0500, James Johnson wrote:

Yes, I'm doing this from windows. I had no idea that access could talk
to mysql. Do you know where I can find out how to do this?

You will want to download and install the MySQL ODBC driver. Once this is
done, you can create linked tables in Access to your MySQL tables. They
will look and act just like Access tables even though the data will
actually reside on your MySQL server. You will be able to scroll through
the tables and edit rows and columns. You can also create queries using
the Access graphical query builder.

Any good book on Access will talk about using ODBC and linked tables.

Thomas Bartkus

[Chris Hope]

Thomas Bartkus wrote:

On Mon, 27 Dec 2004 21:12:56 -0500, James Johnson wrote:

Yes, I'm doing this from windows. I had no idea that access could
talk to mysql. Do you know where I can find out how to do this?

You will want to download and install the MySQL ODBC driver. Once
this is done, you can create linked tables in Access to your MySQL
tables. They will look and act just like Access tables even though the
data will actually reside on your MySQL server. You will be able to
scroll through
the tables and edit rows and columns. You can also create queries
using the Access graphical query builder.

Just be wary of the queries Access creates. The SQL is often pretty
crappy and overly complex with lots of unecessary parentheses.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Thomas Bartkus]

On Tue, 28 Dec 2004 17:22:58 +1300, Chris Hope wrote:

Just be wary of the queries Access creates. The SQL is often pretty
crappy and overly complex with lots of unecessary parentheses.

As will be the case whenever you let a computer generate code for you.
That doesn't diminish its utility nor does it prevent you from writing
your own clean and efficient SQL directly into queries. You also get to
define "PassThrough" queries that bypass the Microsoft SQL parsing engine
completely. In other words, when you don't need the training wheels you
just kick them off.

All in all, Access is pretty slick as a front end to MySQL.
Thomas Bartkus

[James Johnson]

On Tue, 28 Dec 2004 07:26:55 -0600, Thomas Bartkus
<Th***********@Remove.comcast.net> wrote:

On Tue, 28 Dec 2004 17:22:58 +1300, Chris Hope wrote:

Just be wary of the queries Access creates. The SQL is often pretty
crappy and overly complex with lots of unecessary parentheses.

As will be the case whenever you let a computer generate code for you.
That doesn't diminish its utility nor does it prevent you from writing
your own clean and efficient SQL directly into queries. You also get to
define "PassThrough" queries that bypass the Microsoft SQL parsing engine
completely. In other words, when you don't need the training wheels you
just kick them off.

All in all, Access is pretty slick as a front end to MySQL.
Thomas Bartkus

time to buy an access book.