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/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-rpm.html
The architecture designation should also be appropriate to the machine on which the RPM is to be installed; in particular, you should keep in mind that 64-bit RPMs cannot be used with 32-bit operating systems. This section covers the steps ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
By default, generated random passwords have a length of 20 characters. Failed-login tracking and temporary account locking have these characteristics: For failed-login tracking and temporary locking to occur for an account, its FAILED_LOGIN_ATTEMPTS ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
Determination of functional dependence becomes more complex if there are nested outer joins or the join condition does not consist entirely of equality comparisons. The following discussion provides several examples of the ways in which MySQL ...
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, ...