PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
MySQL recognizes the escape sequences shown in Table 12.23, “JSON_UNQUOTE() Special Character Escape Sequences”. The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, path, val[, path, val] ...) Appends ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 10.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
The database tables are automatically created for you, if they do not already exist. * Checking for corrupt, not cleanly closed and upgrade needing tables. Many Linux distributions include a version of the MySQL server, client tools, and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the ...
https://dev.mysql.com/doc/refman/5.7/en/myisamlog.html
If tables are named on the command line, only those tables are updated. To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-6.html
MaxReorgBuildBatchSize: Maximum scan batch size to use for reorganization of table partitions. Increasing this value may speed up table partition reorganization but impacts ongoing traffic as well. Parameters Introduced in NDB 7.6 The following node ...