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/flow-control-functions.html
If there is a combination of signed and unsigned integer types, the result is signed and the precision may be higher. If all types are character string (CHAR or VARCHAR), the result is VARCHAR with maximum length determined by the longest character ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ucs2 character set. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. The sizes of the identifier string columns in the grant ... The following table describes the maximum length for each type of ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
The latter group name contains a space, so it must be quoted with double quote characters. Thus, these statements are equivalent: CREATE USER sql_admin IDENTIFIED WITH authentication_windows AS 'Rafal, Tasha, Administrators, "Power Users"'; CREATE ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
For example, a column that uses the utf8mb4 character set of can be assigned a collation of utf8mb4_0900_as_cs or utf8mb4_bin to make it case-sensitive for full-text searches. | 1.3114095926285 | ... By default or with the IN NATURAL LANGUAGE MODE ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
An ngram is a contiguous sequence of n characters from a given sequence of text. The ngram parser tokenizes a sequence of text into a contiguous sequence of n characters. If you only intend to search for single characters, set ngram_token_size to 1.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgm.html
Note If the management client command to be passed using this option contains any space characters, then the command must be enclosed in quotation marks. If the management client command contains no space characters, the quotation marks are optional. The ndb_mgm management client process is actually not needed to run the ...