Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
Some of these tools are needed no matter whether you use a standard source distribution or a development source tree. To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. If you compile MySQL from a source distribution, CMake configures the distribution to use the installed ...
https://dev.mysql.com/doc/refman/8.4/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...
https://dev.mysql.com/doc/refman/8.4/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). If super_read_only=ON is ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...