TOAD for MySQL

TOAD for MySQL is a professional application built specifically for helping developers and database administrators create, execute, modify and save queries, manage database objects graphically, and develop SQL code.

Plus, it comes packed with several tools for comparing, extracting and searching for objects, managing projects, and importing or exporting data across MySQL databases.

As soon as you run the program, you are offered assistance in configuring the program’s settings. You can choose the preferred layout (“Toad for Oracle,” “MS Query Analyzer,” “SQL Navigator,” or a custom one). The application is able to emulate the layout and settings of the aforementioned products.

You are also allowed to select the skin, grid style, and format for database objects (e.g. tabbed, dropdown).

TOAD for MySQL gives users the possibility to create new MySQL connections or connect to an existing one by selecting the connection type, giving details about the host and password, creating a category, and embedding the MySQL library.

The program enables you to use the database diagram for a visual representation of an object in order to identify relationships between tables, reorganize objects in the diagram, resize each table, as well as select the depth of relationships.

You can create a query without writing or editing SQL statements by dragging tables, adding and joining columns, inserting subqueries, as well as embedding notes. Plus, you can use a “Where” condition for filtering data returned by a query, identify the actual data range, add an “Or” condition, and locate a descriptive value for an ID column by performing searches.

The application allows users to view a data grid for the executed SQL statements and scripts, use the SQL editor for automatically completing SQL statements, exploring and editing scripts, inserting code snippets, as well as recording and playing macros.

What’s more, you can debug scripts that include procedures or functions, stop the SQL statement execution, monitor the total, active and cached threads, compare differences between files (e.g. CS, CSS, BAT, HTML, JAVA, JS, PL, PHP, SQL, XML), automate tasks, design reports, identify differences between objects, as well as transfer scripts, reports or other files to FTP servers.

TOAD for MySQL proves to be a reliable development tool that comes packed with many useful features for helping you automate database object operations, design SQL code with ease, create queries, and compare objects.