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-names.html
For the binary collation of the binary character set, comparisons are based on numeric byte values. For the _bin collation of a nonbinary character set, comparisons are based on numeric character code values, which differ from byte values for ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
For example, bit operations permit numeric or binary string arguments in MySQL 8.0 and higher, but treat hexadecimal and bit literals as numbers by default. Due to the difference in result types, the displayed values differ: High-order 0 digits are ... 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 collation_name] The _charset_name expression is formally called an ...
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 ...For example, in contexts where MySQL expects a date, it interprets any of '2015-07-21', '20150721', and 20150721 as a ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
Event Type Numeric Priority System event 0 Error event 1 Warning event 2 Note/information event 3 The prio value is numeric. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
These elements have the following characteristics: Error code: This value is numeric. SQLSTATE values are taken from ANSI SQL and ODBC and are more standardized than the numeric error codes. This section discusses how error messages originate ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Although ON and OFF have numeric equivalents, the value displayed for event_scheduler by SELECT or SHOW VARIABLES is always one of OFF, ON, or DISABLED. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
What programming languages and APIs are supported by NDB Cluster? NDB Cluster supports the same programming APIs and languages as the standard MySQL Server, including ODBC, .Net, the MySQL C API, and numerous drivers for popular scripting languages ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. For maximum portability, code requiring storage of approximate numeric data values should use FLOAT or DOUBLE PRECISION with no specification of precision or number of digits.
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The return type of a CASE expression result is the aggregated type of all result values: If all types are numeric, the aggregated type is also numeric: If at least one argument is double precision, the result is double precision. The second syntax ...