MySQL,最重要的数据库管理系统流行的开源 SQL 数据库管理系统,由 Oracle Corporation 开发、分发和支持。MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.
MySQL 网站 (http://www.mysql.com/) 提供有关 MySQL 软件的最新信息。The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software.
MySQL 是一个数据库管理系统。MySQL is a database management system.
数据库是数据的结构化集合。它可以是任何东西,从简单的购物清单到图片库或公司网络中的大量信息。要添加、访问和处理计算机数据库中存储的数据,您需要一个数据库管理系统,例如 MySQL Server。由于计算机非常擅长处理大量数据,因此数据库管理系统作为独立实用程序或其他应用程序的一部分,在计算中发挥着核心作用。A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.
MySQL 数据库是关系型数据库。MySQL databases are relational.
关系数据库将数据存储在单独的表中,而不是将所有数据放在一个大库房中。数据库结构被组织成针对速度进行优化的物理文件。具有数据库、表、视图、行和列等对象的逻辑模型提供了灵活的编程环境。您可以设置管理不同数据字段之间关系的规则,例如一对一、一对多、唯一、必需或可选,以及不同表之间的“指针”。数据库强制执行这些规则,因此,对于设计良好的数据库,您的应用程序永远不会看到不一致、重复、孤立、过时或丢失的数据。 A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structures are organized into physical files optimized for speed. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up rules governing the relationships between different data fields, such as one-to-one, one-to-many, unique, required or optional, and “pointers” between different tables. The database enforces these rules, so that with a well-designed database, your application never sees inconsistent, duplicate, orphan, out-of-date, or missing data.
“MySQL” 的 SQL 部分代表“结构化查询语言”。 SQL 是用于访问数据库的最常见的标准化语言。根据您的编程环境,您可以直接输入 SQL(例如,生成报告)、将 SQL 语句嵌入到用其他语言编写的代码中,或者使用隐藏 SQL 语法的特定于语言的 API。The SQL part of “MySQL” stands for “Structured Query Language”. SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax.
SQL 由 ANSI/ISO SQL 标准定义。SQL 标准自 1986 年以来不断发展,并且存在多个版本。在本手册中,“SQL-92”指 1992 年发布的标准,“SQL:1999”指 1999 年发布的标准,而“SQL:2003”指当前版本的标准。我们使用短语“SQL 标准”来表示任何时候的当前 SQL 标准版本。SQL is defined by the ANSI/ISO SQL Standard. The SQL standard has been evolving since 1986 and several versions exist. In this manual, “SQL-92” refers to the standard released in 1992, “SQL:1999” refers to the standard released in 1999, and “SQL:2003” refers to the current version of the standard. We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time.
MySQL 软件是开源的。MySQL software is Open Source.
开源意味着任何人都可以使用和修改该软件。任何人都可以从互联网上下载 MySQL 软件并使用它,而无需支付任何费用。如果您愿意,您可以研究源代码并更改它以满足您的需要。 MySQL 软件使用 GPL(GNU 通用公共许可证)http://www.fsf.org/licenses/ 来定义在不同情况下您可以使用该软件执行哪些操作,不可以执行哪些操作。如果您对 GPL 感到不舒服或者需要将 MySQL 代码嵌入到商业应用程序中,您可以从我们这里购买商业许可版本。有关详细信息,请参阅 MySQL 许可概述 (http://www.mysql.com/company/legal/licensing/)。 Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs. The MySQL software uses the GPL (GNU General Public License), http://www.fsf.org/licenses/, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from us. See the MySQL Licensing Overview for more information (http://www.mysql.com/company/legal/licensing/).
MySQL 数据库服务器非常快速、可靠、可扩展且易于使用。The MySQL Database Server is very fast, reliable, scalable, and easy to use.
如果这就是您正在寻找的,您应该尝试一下。 MySQL Server 可以在台式机或笔记本电脑上与其他应用程序、Web 服务器等一起舒适地运行,几乎不需要或不需要关注。如果您将整台机器专用于 MySQL,则可以调整设置以利用所有可用的内存、CPU 功率和 I/O 容量。 MySQL 还可以扩展到联网的机器集群。If that is what you are looking for, you should give it a try. MySQL Server can run comfortably on a desktop or laptop, alongside your other applications, web servers, and so on, requiring little or no attention. If you dedicate an entire machine to MySQL, you can adjust the settings to take advantage of all the memory, CPU power, and I/O capacity available. MySQL can also scale up to clusters of machines, networked together.
MySQL Server 最初开发的目的是为了比现有解决方案更快地处理大型数据库,并且已在要求严格的生产环境中成功使用了多年。尽管在不断发展,MySQL Server 如今提供了一组丰富且有用的功能。其连接性、速度和安全性使 MySQL Server 非常适合访问 Internet 上的数据库。MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.
MySQL Server 在客户端/服务器或嵌入式系统中工作。MySQL Server works in client/server or embedded systems.
MySQL 数据库软件是一个客户端/服务器系统,由支持不同后端的多线程 SQL 服务器、多个不同的客户端程序和库、管理工具以及各种应用程序编程接口 (API) 组成。The MySQL Database Software is a client/server system that consists of a multithreaded SQL server that supports different back ends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs).
我们还提供 MySQL Server 作为嵌入式多线程库,您可以将其链接到您的应用程序中,以获得更小、更快、更易于管理的独立产品。We also provide MySQL Server as an embedded multithreaded library that you can link into your application to get a smaller, faster, easier-to-manage standalone product.
有大量贡献的 MySQL 软件可供使用。A large amount of contributed MySQL software is available.
MySQL Server 拥有一组与我们的用户密切合作开发的实用功能。您最喜欢的应用程序或语言很可能支持 MySQL 数据库服务器。MySQL Server has a practical set of features developed in close cooperation with our users. It is very likely that your favorite application or language supports the MySQL Database Server.
MySQL HeatWave。MySQL HeatWave.
MySQL HeatWave 是一项完全托管的数据库服务,由 MySQL HeatWave 内存中查询加速器提供支持。它是唯一一款在一个 MySQL 数据库中将事务、跨数据仓库和数据湖的实时分析以及机器学习结合在一起的云服务;没有 ETL 重复的复杂性、延迟、风险和成本。它可在 OCI、AWS 和 Azure 上使用。了解更多信息,请访问:https://www.oracle.com/mysql/。MySQL HeatWave is a fully managed database service, powered by the MySQL HeatWave in-memory query accelerator. It is the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one MySQL Database; without the complexity, latency, risks, and cost of ETL duplication. It is available on OCI, AWS, and Azure. Learn more at: https://www.oracle.com/mysql/.
“MySQL”的官方发音是“My Ess Que Ell”(不是“我的续集”),但我们不介意您将其发音为“我的续集”或其他本地化方式。The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way.