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
With LIKE you can use the following two wildcard characters in the pattern: % matches any number of characters, even zero characters. mysql> SELECT 'David!' LIKE 'David_'; -> 1 mysql> SELECT 'David!' LIKE '%D%v%'; -> 1 To test for literal instances ... Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
By default, validate_password.changed_characters_percentage permits all of the characters from the current password to be reused in the new password. If set to 100 percent, all of the characters from the current password are rejected, regardless of ... This section describes the system and status variables that validate_password provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
There is no restriction or check in place to validate character set settings. memcached stores and retrieves keys and values in bytes and is therefore not character set sensitive. However, you must ensure that the memcached client and the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. The ? characters should not be enclosed within quotation marks, even if you intend to bind them ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
Resource group names are identifiers like table and column names, and need not be quoted in SQL statements unless they contain special characters or are reserved words. Group names are not case-sensitive and may be up to 64 characters long. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
Values used for SOURCE_HOST and other CHANGE REPLICATION SOURCE TO options are checked for linefeed (\n or 0x0A) characters. The presence of such characters in these values causes the statement to fail with an error. When the receiver thread is ...] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation characteristics. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Representation of metadata must satisfy these requirements: All metadata must be in the same character set. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it. The permissible Unicode characters in identifiers are those in the Basic Multilingual Plane (BMP). Identifiers thus may contain these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
charset charset_name, \C charset_name Change the default character set and issue a SET NAMES statement. This enables the character set to remain synchronized on the client and server if mysql is run with auto-reconnect enabled (which is not ...