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/signal.html
Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). It can be an SQLSTATE value (a 5-character string literal) or a condition_name that refers to a named condition previously defined with DECLARE ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
Specifying the CHARACTER SET binary attribute for a character data type causes the column to be created as the corresponding binary data type: CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB. In some cases, MySQL silently ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
This statement may be a compound statement made up of several statements separated by semicolon (;) characters. You should avoid the use of the backslash (\) character because that is the escape character for MySQL. Each stored program contains a ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/user-variables.html
User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user variable name can contain other characters if you quote it as a string or identifier (for example, @'my-var', ... You ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. If ...This syntax differs slightly from standard SQL comment syntax, as discussed in Section 1.6.2.4, “'--' as the Start of a ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
If you add a version number after the ! character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version number. Because of this nice syntax, MySQL Server doesn't support the standard ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. | +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.