Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-geometrycollection-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. If any geometry argument is not a syntactically ...
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
If any argument is not a proper WKB or geometry representation of the proper object type, the return value is NULL. If the number of arguments is less than two, the return value is NULL. If any argument does not represent a LinearRing (that is, not ... MySQL provides a set of useful nonstandard functions for creating geometry ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is NULL. A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
The column is NULL if the server has not yet accessed the table. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
row *************************** id: 1 select_type: SIMPLE table: cs partitions: NULL type: const possible_keys: PRIMARY,name key: name key_len: 194 ref: const rows: 1 filtered: 100.00 Extra: Using index *************************** 2. row ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
Both functions handle null or invalid input as follows: If at least one of the arguments is NULL, the function returns NULL. MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification.
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> ...Suppose that your pet records can be described as shown ...