MySql 中文参考指南

Chapter 33 MySQL Workbench

MySQL Workbench 提供了一个图形化工具，用于与 MySQL 服务器和数据库配合使用。MySQL Workbench 完全支持 MySQL 5.5 及更高版本。

MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench fully supports MySQL versions 5.5 and higher.

以下讨论简要描述了 MySQL Workbench 功能。有关更多信息，请参见 MySQL Workbench 手册，可在 [role="bare"[role="bare"]https://dev.mysql.com/doc/workbench/en/] 获取。

The following discussion briefly describes MySQL Workbench capabilities. For more information, see the MySQL Workbench manual, available at [role="bare"https://dev.mysql.com/doc/workbench/en/].

MySQL Workbench 提供五项主要功能领域：

MySQL Workbench provides five main areas of functionality:

  1. SQL Development: Enables you to create and manage connections to database servers. As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. This functionality replaces that previously provided by the Query Browser standalone application.

  2. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views.

  3. Server Administration: Enables you to create and administer server instances.

  4. Data Migration: Allows you to migrate from Microsoft SQL Server, Sybase ASE, SQLite, SQL Anywhere, PostreSQL, and other RDBMS tables, objects and data to MySQL. Migration also supports migrating from earlier versions of MySQL to the latest releases.

  5. MySQL Enterprise Support: Support for Enterprise products such as MySQL Enterprise Backup and MySQL Audit.

MySQL Workbench 有社区版和商业版两个版本。社区版免费提供。商业版提供附加企业级功能，例如生成数据库文档，只需极低成本。

MySQL Workbench is available in two editions, the Community Edition and the Commercial Edition. The Community Edition is available free of charge. The Commercial Edition provides additional Enterprise features, such as database documentation generation, at low cost.