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. 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. 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.
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. 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.įurthermore, 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 are also allowed to select the skin, grid style, and format for database objects (e.g. The application is able to emulate the layout and settings of the aforementioned products. You can choose the preferred layout (“Toad for Oracle,” “MS Query Analyzer,” “SQL Navigator,” or a custom one). Plus, it comes packed with several tools for comparing, extracting and searching for objects, managing projects, and importing or exporting data across MySQL databases.Īs soon as you run the program, you are offered assistance in configuring the program’s settings.
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.
0 kommentar(er)
