8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 33 MySQL Workbench
中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

第 33 章 MySQL WorkbenchChapter 33 MySQL Workbench

MySQL Workbench 提供了一个用于管理 MySQL 服务器和数据库的图形化工具。MySQL Workbench 在 MySQL Server 8.0 上开发和测试。MySQL Workbench 可以连接到 MySQL Server 8.4 及更高版本,但某些 MySQL Workbench 功能可能无法在这些更新的服务器版本中正常工作。MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench is developed and tested with MySQL Server 8.0. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions.

以下讨论简要描述了 MySQL Workbench 的功能。更多信息,请参见 MySQL Workbench 手册,网址为 https://docs.oracle.com/cd/E17952_01/workbench-en/。The following discussion briefly describes MySQL Workbench capabilities. For more information, see the MySQL Workbench manual, available at https://docs.oracle.com/cd/E17952_01/workbench-en/.

MySQL Workbench 提供五个主要功能区域:MySQL Workbench provides five main areas of functionality:

  • SQL 开发:让您能够创建和管理与数据库服务器的连接。除了可以配置连接参数外,MySQL Workbench 还提供了使用内置 SQL 编辑器在数据库连接上执行 SQL 查询的功能。此功能取代了以前由独立应用程序 Query Browser 提供的功能。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.

  • 数据建模:使您能够以图形方式创建数据库模式的模型,在模式与实时数据库之间进行反向和正向工程,并使用综合表编辑器编辑数据库的各个方面。表编辑器提供易于使用的功能,用于编辑表、列、索引、触发器、分区、选项、插入和权限、过程和视图。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.

  • 服务器管理:使您能够创建和管理服务器实例。Server Administration: Enables you to create and administer server instances.

  • 数据迁移:允许您将 Microsoft SQL Server、Sybase ASE、SQLite、SQL Anywhere、PostreSQL 及其他 RDBMS 的表、对象和数据迁移到 MySQL。迁移还支持将早期版本的 MySQL 数据迁移到最新版本。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.

  • MySQL 企业支持:提供对企业产品的支持,如 MySQL 企业备份和 MySQL 审计。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.