没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
















MySQL 8.0 Reference Manual
Including MySQL NDB Cluster 8.0

Abstract
This is the MySQL™ Reference Manual. It documents MySQL 8.0 through 8.0.18, as well as NDB Cluster
releases based on version 8.0 of NDB through 8.0.17-ndb-8.0.17, respectively. It may include documentation of
features of MySQL versions that have not yet been released. For information about which versions have been
released, see the MySQL 8.0 Release Notes.
MySQL 8.0 features. This manual describes features that are not included in every edition of MySQL 8.0; such
features may not be included in the edition of MySQL 8.0 licensed to you. If you have any questions about the
features included in your edition of MySQL 8.0, refer to your MySQL 8.0 license agreement or contact your Oracle
sales representative.
For notes detailing the changes in each release, see the MySQL 8.0 Release Notes.
For legal information, including licensing information, see the Preface and Legal Notices.
For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss
your issues with other MySQL users.
Document generated on: 2019-05-12 (revision: 62014)

iii
Table of Contents
Preface and Legal Notices ....................................................................................................... xxvii
1 General Information ................................................................................................................... 1
1.1 About This Manual .......................................................................................................... 2
1.2 Typographical and Syntax Conventions ........................................................................... 2
1.3 Overview of the MySQL Database Management System ................................................... 4
1.3.1 What is MySQL? .................................................................................................. 4
1.3.2 The Main Features of MySQL ............................................................................... 5
1.3.3 History of MySQL ................................................................................................. 8
1.4 What Is New in MySQL 8.0 ............................................................................................. 9
1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL
8.0 ...................................................................................................................................... 30
1.6 MySQL Information Sources .......................................................................................... 43
1.6.1 MySQL Websites ............................................................................................... 43
1.6.2 MySQL Mailing Lists ........................................................................................... 44
1.6.3 MySQL Community Support at the MySQL Forums .............................................. 46
1.6.4 MySQL Community Support on Internet Relay Chat (IRC) .................................... 46
1.6.5 MySQL Enterprise .............................................................................................. 46
1.7 How to Report Bugs or Problems .................................................................................. 47
1.8 MySQL Standards Compliance ...................................................................................... 51
1.8.1 MySQL Extensions to Standard SQL ................................................................... 52
1.8.2 MySQL Differences from Standard SQL .............................................................. 55
1.8.3 How MySQL Deals with Constraints .................................................................... 56
1.9 Credits .......................................................................................................................... 60
1.9.1 Contributors to MySQL ....................................................................................... 60
1.9.2 Documenters and translators .............................................................................. 64
1.9.3 Packages that support MySQL ............................................................................ 65
1.9.4 Tools that were used to create MySQL ............................................................... 66
1.9.5 Supporters of MySQL ......................................................................................... 66
2 Installing and Upgrading MySQL .............................................................................................. 69
2.1 General Installation Guidance ........................................................................................ 71
2.1.1 Which MySQL Version and Distribution to Install .................................................. 71
2.1.2 How to Get MySQL ............................................................................................ 73
2.1.3 Verifying Package Integrity Using MD5 Checksums or GnuPG .............................. 73
2.1.4 Installation Layouts ............................................................................................. 86
2.1.5 Compiler-Specific Build Characteristics ................................................................ 86
2.2 Installing MySQL on Unix/Linux Using Generic Binaries .................................................. 86
2.3 Installing MySQL on Microsoft Windows ......................................................................... 89
2.3.1 MySQL Installation Layout on Microsoft Windows ................................................ 92
2.3.2 Choosing an Installation Package ....................................................................... 92
2.3.3 MySQL Installer for Windows .............................................................................. 93
2.3.4 MySQL Notifier ................................................................................................. 116
2.3.5 Installing MySQL on Microsoft Windows Using a noinstall ZIP Archive ............ 127
2.3.6 Troubleshooting a Microsoft Windows MySQL Server Installation ........................ 135
2.3.7 Windows Postinstallation Procedures ................................................................ 137
2.4 Installing MySQL on macOS ........................................................................................ 139
2.4.1 General Notes on Installing MySQL on macOS .................................................. 139
2.4.2 Installing MySQL on macOS Using Native Packages .......................................... 140
2.4.3 Installing and Using the MySQL Launch Daemon ............................................... 144
2.4.4 Installing and Using the MySQL Preference Pane .............................................. 147
2.5 Installing MySQL on Linux .