PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit Default Handling If a data type specification includes no explicit DEFAULT value, MySQL determines the default value as follows: If the column can ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-introduction.html
In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA ROUTINES table), users who have insufficient privileges see NULL. If this field is NULL, it means that the value of the column is always NULL. INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-summary-tables.html
A NULL row in each error summary table is used to aggregate statistics for all errors that lie out of range of the instrumented errors. For example, if MySQL Server errors lie in the range from M to N and an error is raised with number Q not in that ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_Crosses() handles its arguments as described in the ... The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-options-system-variables.html
mysqlx_ssl_ca Command-Line Format --mysqlx-ssl-ca=file_name System Variable mysqlx_ssl_ca Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value NULL The mysqlx_ssl_ca system variable is like ssl_ca, except that it applies to X ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/9.7/en/all-subqueries.html
The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The expression is unknown (that is, NULL) if table t2 contains (0,NULL,1). The expression is TRUE if table t2 ...
https://dev.mysql.com/doc/refman/9.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_IsClosed() returns 0 if ls is not closed, and NULL ...You can extract particular points of a LineString, count the number of points that it contains, or obtain its ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. If the default value is NULL or was not specified, this column reports NULL. An explicitly specified non-NULL default ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...