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/charset-collation-coercibility.html
In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; ...
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-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
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/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A core field is set up automatically for error events. However, its ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action.
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision values and eight bytes for double-precision values. For FLOAT, the SQL standard permits an optional specification of the precision (but ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...