PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Note MySQL uses C escape syntax in strings (for example, \n to represent the newline character). Note Aggregate queries involving NOT LIKE comparisons with columns containing NULL may yield unexpected results. Table 14.13 String Comparison ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. mysql> SELECT SOUNDEX('Hello'); -> 'H400' mysql> SELECT SOUNDEX('Quadratically'); -> 'Q36324' Note This function implements the original ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
Note Trailing spaces are removed when CHAR values are retrieved unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. Note MySQL follows the standard SQL specification, and does not remove trailing spaces from VARCHAR values. The string data ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X when the “linked” outer expression oe_i is not NULL TRUE when the “linked” outer expression oe_i is NULL Note Trigger functions are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Note If MySQL is upgraded from an older version but the grant tables have not been upgraded from MyISAM to InnoDB, the server considers them read only and account-management statements produce an error. Note Like the mysql.func system table, the ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
Note This plugin is intended for testing and development purposes, and is not for use in production environments or on servers that are exposed to public networks. You can look in the server error log for a message indicating whether authentication ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
Review the Release Notes for information about fixes, changes, and new features. Note For supported Linux distributions, the preferred method for upgrading package-based installations is to use the MySQL software repositories (MySQL Yum Repository, ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
If the server automatically enables encrypted connection support, it writes a note to the error log. Note Host name identity verification with VERIFY_IDENTITY does not work with self-signed certificates that are created automatically by the server ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. Note For statements that assign or modify account passwords (ALTER USER, CREATE USER, and SET PASSWORD), the validate_password capabilities ... The ...