PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/select.html
This exception may not apply to const or system tables that are used on the NULL-complemented side of an outer join (that is, the right-side table of a LEFT JOIN or the left-side table of a RIGHT JOIN. SELECT [ALL | DISTINCT | DISTINCTROW ] ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a maximum of 64 distinct members. A SET is a string object that can have zero or more values, each of which ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SHOW CREATE TABLE quotes table and column names ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). A string object that can have only one ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the ...If the argument is not a valid consumer name, an error ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
(See Section 11.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 Division by zero produces a NULL result: mysql> SELECT 102/(1-1); -> NULL A division is calculated with BIGINT arithmetic only if performed in a context where its ... Table 12.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the audit_log_exclude_accounts system variable is NULL. For information about using JSON data in MySQL, see ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
row *************************** Table: new_table Create Table: CREATE TABLE `new_table` ( `c1` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 The cast functions are useful for sorting ENUM columns in lexical order. Examples: For conversion ... Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
To tell the server to perform no conversion of result sets or error messages, set character_set_results to NULL or binary: SET character_set_results = NULL; SET character_set_results = binary; For more information about character sets and error ...