tags:

views:

152

answers:

5

HI I want to how a gui for building my queries. It would be nice for it to have syntax validation. Ie if I have a missing quote it'll tell me. It balances brackets. It's simple but very easy to get wrong.

A: 

Heidi SQL

heidi sql on the web

KB22
+3  A: 

You can also check out Toad for MySQL at here. The doc says its a free ware. I guess this will address most of your problems

Cshah
just checked this out - impressive! best of the 4 programs mentioned so far. and free indeed.
ax
bit a of learning curve, but it looks like its the only one to feature auto-completion and multiple tabs
Richard
+1  A: 

Use NaviCat You can find those on Navicat

Senthil Kumar Bhaskaran
A: 

SQLyog. Free community edition, paid enterprise edition with great features such as Query Profiling, Synchronization, Advanced Connectivity. see also http://lists.mysql.com/mysql/217884 .

ax
A: 

Maybe try RazorSQL - it has an SQL query builder and SQL formatter.

Ahmad