Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-general-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. mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); ... The functions listed in this ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
SUBPARTITION_NAME If the PARTITIONS table row represents a subpartition, the name of subpartition; otherwise NULL. For partitions whose PARTITION_METHOD is other than RANGE or LIST, this column is always NULL. However, the values of the ...Each row ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-row.html
mysql_fetch_row() retrieves the next row of a result set: When used after mysql_store_result() or mysql_store_result_nonblocking(), mysql_fetch_row() returns NULL if there are no more rows to retrieve. When used after mysql_use_result(), ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. This is a system schema that ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
This does not perform any defragmentation, which requires an OPTIMIZE TABLE or null ALTER TABLE statement. The columns must permit NULL values and not have any explicit default value other than NULL. row *************************** Table: t1 Create ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes.html
This program illustrates how to use secondary indexes in the NDB API. The source code for this example may be found in the NDB Cluster source tree, in storage/ndb/ndbapi-examples/ndbapi_simple_index/main.cpp.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --csvopt=string Command-Line Format --csvopt=opts Type String Default Value [none] Provides a shortcut method for ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...