Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
For example, this polygon is geometrically invalid: POLYGON((0 0, 0 0, 0 0, 0 0, 0 0)) ST_Validate() returns the geometry if it is syntactically well-formed and is geometrically valid, NULL if the argument is not syntactically well-formed or is not ...Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...TABLE does not allow for any arbitrary filtering of rows; that is, TABLE does not support any WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. Thus, it does not cause ON DELETE triggers to fire, it cannot be performed for InnoDB tables with parent-child ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.4/en/workbench.html
MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions. MySQL Workbench ...For more information, see the MySQL Workbench manual, available at ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/intro.html
It is a multi-platform, high-performance tool, offering rich features like “hot” (online) backup, incremental and differential backup, selective backup and restore, support for direct cloud storage backup, backup encryption and compression, and ... MySQL Enterprise Backup 8.4.6 is a backup utility for MySQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-start-client.html
This section covers starting the MySQL Cluster Manager client and connecting to the MySQL Cluster Manager agent. MySQL Cluster Manager 8.4.6 includes a command-line client mcm, located in the installation bin directory. To end a client session, use ...You can connect to any MySQL Cluster Manager agent with an mcm client on any platform where it is ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...Processing these results involves a different approach than for the single-statement case: After handling the result from the first statement, it is necessary to check whether more results exist and process them in turn if ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-keyring-plugins.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. Other MySQL or general header files might also be needed, depending on the plugin capabilities ...This section describes how to write a server-side keyring plugin that can be used by service functions to perform key-management ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/installation-source.html
This section describes how to compile, install, and test NDB Operator from source. The following prerequisites must be installed on the system to build and test NDB Operator: Golang 1.16 or newer to compile the operator. The Makefile included with ...If you do not already have the source code, see Section 2.2, “Obtaining NDB ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-innodb-cluster.html
MySQL Router is part of InnoDB Cluster and is lightweight middleware that provides transparent routing between your application and back-end MySQL Servers. It is used for a wide variety of use cases, such as providing high availability and ...The ...