mysql - development tools

Posted by IrishGringo on June 29, 2008 at 3:33am

stupid quesiton. I am looking for a tool to look at mySQL data, perhaps a query builder. something like the query builder in access would be awsome. I am just learning DRUPAL, and MySQL a well. using WAMP, and there is a field data view, I need to see the DB relations, the data types better... is there a better tool out there then phpmyadmin?

Comments

phpmyadmin is included in

Posted by cog.rusty on June 29, 2008 at 3:58am

phpmyadmin is included in most WAMP packages and this is what almost everyone uses, for good reasons.

It does have a "query by example" builder (Query tab, when you have not selected any table), although many people find that it slows them down.

What more do you want it to do?

I second the phpmyadmin

Posted by TonyV on June 29, 2008 at 12:58pm

I second the phpmyadmin advice.

Tony Valle
Promethius Consulting, LLC

------------------------------------------------------------------
Tony Valle
Promethius Consulting, LLC

DB tools to view & query the Drupal database

Posted by pete-drupal on June 29, 2008 at 9:39am

Some other GUI front-ends to view and query the Drupal (MySQL) database:

You should be able to connect with MSAccess.
More info: http://drupal.org/node/228613
You can also try "Toad for MySQL Freeware"
More info: http://www.quest.com/toad-for-mysql
(This product is currently freeware)

There are many others (not necessarily freeware or open source)

SQLyog MySQL GUI (http://www.webyog.com/en/)
MySQL-Front (http://www.mysqlfront.de/)
...