Search Results
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) ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 14.15, “Information Functions”). The ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. Stored routines can be particularly ...
https://dev.mysql.com/doc/refman/8.4/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. If the sorting rules for your language are too complex to be handled with simple arrays, ...
https://dev.mysql.com/doc/refman/8.4/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery results. This section discusses these optimizations, particularly with regard to the challenges that NULL values present. The last part of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-reload-saved.html
Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a ...