One, MySQL GUI Tools
MySQL official provides a visual interface to the MySQL database management console, provides four graphical applications, these graphical management tools can greatly improve database management, backup, migration and query efficiency. They are:
MySQL Migration Toolkit
MySQL Administrator
MySQL Query Browser
MySQL Workbench
1. MySQL Query Browser
The MySQL query browser is the simplest visualization tool for creating, executing, and optimizing SQL queries for MySQL database servers. MySQL Query Browser Main features:
The query toolbar navigation buttons allow you to browse through the history of the query and review and rerun previous queries. You can save the query and open the query file *.qbquery.
Easily manage multiple queries with the results window
Compare multiple queries displayed in the results window by viewing tab-delimited, or vertical or horizontal unions. In addition, the interpretation button can be used to get an explanation of the output for the current query. The comparison button allows you to quickly compare the results of two queries, allowing you to determine where rows have been inserted, updated, or deleted.
Script Editing and debugging
The scripting area is characterized by numbering and syntax highlighting. In addition, the Script Debug button allows you to set breakpoints and control the execution of the statement and script.
Built-in Help
Instantly help you get selected objects, parameters, and functions, you can view the MySQL syntax statement syntax, functions, parameters.
2. MySQL Administrator
MySQL administrator makes it easier for users to manage and monitor your MySQL environment and gain better visibility into the database.
MySQL Administrator features the main features:
Start/stop MySQL service
Health view: Connect Health Real-time graph view (connection usage, traffic, SQL query number), Memory Health view (query Cache hitrate,key efficiency), state variable view (normal, performance, network, execute command, mix, new variable), System variable view (normal, connection, SQL, memory, table type, new variable)
3. Migration Toolkit
You can copy the database to MySQL from a database such as Ms Sql,oracle.
4. MySQL Workbench
Add EER chart (abbreviation for Extended entity-relationship)
Using the default schema, creating new tables, new views, and so on
You can import SQL scripts
Disadvantages:
Mysql Query browser always uses too much memory after a few queries.
When manually installing the MySQL GUI Tools 5.0, naming the directory name Chinese, or placing it on the desktop to perform MySQL Query Browser, this problem can occur in the Chinese system: ... MySQL GUI Tools 5.0\xml\mysqlqb_functions.xml (Error
There are not many Chinese and Chinese materials.
Import Export support format is too small.