MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 221 to 230 of 236 total results

https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html

For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...

14.8.2 Regular Expressions

https://dev.mysql.com/doc/refman/8.0/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 ...

19.1.3.1 GTID Format and Storage

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html

A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...

19.1.2.1 Setting the Replication Source Configuration

https://dev.mysql.com/doc/refman/8.0/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 ...

19.1.6 Replication and Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/8.0/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 ...

7.6.4.3 Rewriter Query Rewrite Plugin Reference

https://dev.mysql.com/doc/refman/8.0/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 ...

15.2.15.1 The Subquery as Scalar Operand

https://dev.mysql.com/doc/refman/8.0/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 ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

14.16.12 Spatial Aggregate Functions

https://dev.mysql.com/doc/refman/8.0/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 ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/8.0/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 ...

Displaying 221 to 230 of 236 total results