Good MySQL editor needed

Other than Eclipse :)

[Distel]

Hi

Does anyone know a good Editor to work with MySQL? I need one with a GUI for those MySQL tables so I don't need to work from the command line or with PHP code all the time. It would be very nice if it was a free or a cheap program. And also if it was an alternative to Eclipse. :)

Thanks!

[bcc1234]

Check sourceforge/freshmeat, there are tons of front-ends available.

[shasan]

highly recommend phpMyAdmin - web based though.

[Distel]

Cool, I'll try those out. Thanks!

[shady]

mysql-front is fantastic and I recommend it to anyone!

Personally, I have trouble with phpmyadmin failing with "page cannot be displayed" quite frequently, causing me to have to refresh a number of times before the page is displayed.

mysql-front is a free gui front end which runs on your PC rather than in a browser and uses myodbc to connect.

It allows easy filtering of data and many commands.

Another program which is useful is SQLyog, which is good for running queries and exporting results to files or clipboard. Particularly useful, is that you have control over what the delimiters are between fields (including none!). This allows you to build up sql queries from sql easily without the need for multiple "concat" commands!

Between the two, I find them a very good replacement for phpmyadmin.

[epptom]

mySQLGUI (linux/win32 application) works well - especially if you're not comfortable (for security or time reasons) installing a web application. It's available on the mySQL website.

[Distel]

This is excellent info, guys! Thanks!

[nevasport]

MySQL Control Center from mysql.com is great to do SQL queries