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/mysqladmin.html
(SystemV Unix systems and perhaps others are subject to this problem.) If the new_password value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotation marks. You can use it to check ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). There ... Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values. The permissible maximum length is the same for BINARY and VARBINARY as it is for CHAR and VARCHAR, ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
The COLLATE attribute can be used if preceded by a CHARACTER SET specification. The COMMENT characteristic is a MySQL extension, and may be used to describe the stored routine. The LANGUAGE characteristic indicates the language in which the routine ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
A “relaxed” syntax is permitted, but is deprecated: Any punctuation character may be used as the delimiter between date parts. Beginning with MySQL 8.0.29, using any character other than the dash (-) as the delimiter raises a warning, as shown ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so that it can be indexed as a word character. General information about adding collations is given in Section 12.14, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
Note For an explanation and example of the differences between this function and JSON_MERGE_PRESERVE(), see JSON_MERGE_PATCH() compared with JSON_MERGE_PRESERVE(). Each of these sequences begins with a backslash (\), known as the escape character.
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. --default-character-set=charset_name Command-Line Format --default-character-set=name Type String ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...