https://dev.mysql.com/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, most columns displayed by SHOW TABLE STATUS are 0 or NULL except that Name indicates the view name, Create_time indicates the creation time, and Comment ...
https://dev.mysql.com/storage-requirements.html
While a NULL itself does not require any storage space, NDB reserves 4 bytes per row if the table definition contains any columns allowing NULL, up to 32 NULL columns. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...
https://dev.mysql.com/tables-table.html
Not all storage engines update this time, in which case, the value is always NULL. For views, most TABLES columns are 0 or NULL except that TABLE_NAME indicates the view name, CREATE_TIME indicates the creation time, and TABLE_COMMENT says VIEW. The ...
https://dev.mysql.com/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. When an operator is used with operands ...
https://dev.mysql.com/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/writing-information-schema-plugins.html
If no cleanup is needed, this descriptor member can be NULL (as in the example shown). static ST_FIELD_INFO simple_table_fields[]= { {"NAME", 10, MYSQL_TYPE_STRING, 0, 0 0, 0}, {"VALUE", 6, MYSQL_TYPE_LONG, 0, MY_I_S_UNSIGNED, 0, 0}, {0, 0, ... This ...
https://dev.mysql.com/xml-functions.html
Table 12.15 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/adding-native-function.html
This function should also set maybe_null = 0 if the main function cannot return a NULL value. The function can check whether any of the function arguments can return NULL by checking the arguments' maybe_null variable. If you want to return NULL ...
https://dev.mysql.com/any-in-some-subqueries.html
The expression is unknown (that is, NULL) if table t2 contains (NULL,NULL,NULL). The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if ...
