How to better visualizing data while working with MySQL Database?

To double check if my code does the right thing (python and php querying a huge dMySQL dabase) I do ssh to my server and fireup mysql. Then I start querying... and querying... and querying... And the querys sometimes are really long.

That is troublesome. :-)

Because I have to double check a lot of times if my code does the right thing, I thought if there is a better approach. There must be one! At least I hope!!

What would you suggest?

Update:

I am using a Ubuntu Linux machine and the server where MySQL is running on is Ubuntu, too. The Server has Apache and PHP running on it.

Have you tried using something like Querious for the mac or Mysql Query browser for most platforms ?

I personally use Navicat and I love it. Check out Toad for MySQL for a free tool.

To see the changes in the database you have no other than to connect to the db and see the results. Best idea is to use some graphical tool to see the changes in the db. This will help you.

1. Top 10 mysql graphical tools