Search Results
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
For example, the twenty-third transaction to be committed originally on the server with the UUID 3E11FA47-71CA-11E1-9E33-C80AA9429562 has this GTID: 3E11FA47-71CA-11E1-9E33-C80AA9429562:23 The upper limit for sequence numbers for GTIDs on a server ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
This server ID is used to identify individual servers within the replication topology, and must be a positive integer between 1 and (232)−1. To configure a source to use binary log file position based replication, you must ensure that binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. The following sections contain ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
rewriter_verbose System Variable rewriter_verbose Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer For internal use. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
For example, LIMIT requires literal integer arguments, and LOAD DATA requires a literal string file name. In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
Cardinality is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
In MySQL, the SRID value is an integer associated with the geometry value. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...