20 MySQL Admin and Development Tools and cheat sheets
DreamCoder for MySQL (win)
DreamCoder works with all MySQL versions from 3.23 to 6.0 and it supports all MySQL features including tables, views, procedures, functions, triggers, InnoDB Tables, foreign keys , UDFS, BLOB Types, etc. It also includes the most advanced options for data manipulation, build queries visually, execute queries, script execution, reports generation, database monitoring and export and import data to/from most popular file formats. DreamCoder for MySQL is easy to use for the novice MySQL user and is powerful enough for any expert user. Commercial license.
DB Tools Manager Professional (win)
DBManager is a fairly powerful application data management data management. With builtin support for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines, making it one of the most advanced database application. The free edition (Standard Edition) has a minimun set of features that makes it ideal for new database users to perform basic database management, you can use this for non commercial use.
WinSQL Lite
WinSQL Lite is a database client that can connect to any database through ODBC. It provides an interface that allows you to run queries, create tables, browse data, edit/insert records and more. The multi-tabbed interface allows you to manage multiple queries and switch between the results. A Pro version is also available that offers some additional features
MyDB Studio (win)
MyDB Studio is a complete collection of powerful tools for MySQL Server administration. MyDB Studio (freeware) is designed for MySQL developers and administrators to rapidly manage, create and execute queries and develop SQL and Php code more efficiently. Keep an eye out for the upcoming Adobe Air version of MyDB Studio, that will be cool.
SQL Cheat Sheets
SQL Cheat Sheet
