PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/upgrade-best-practices.html
MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...
https://dev.mysql.com/doc/refman/9.7/en/windows-choosing-package.html
For MySQL 9.7, there are multiple installation package formats to choose from when installing MySQL on Windows. The package formats described in this section are: MySQL Installation MSI MySQL noinstall ZIP Archives MySQL Docker Images MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/windows-installation.html
MySQL is available for Microsoft Windows 64-bit operating systems only. There are different methods to install MySQL on Microsoft Windows: the MSI, the standard binary distribution (packaged as a compressed file) containing all of the necessary ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. For example, to enable or disable the InnoDB adaptive hash index, you can ...
https://dev.mysql.com/doc/refman/9.7/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-filter-definitions.html
Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect the plugin to be removed in a future version of MySQL. For more information about the audit log ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...