MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 271 to 280 of 289 total results

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

The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, the following statements are completely different: mysql> INSERT INTO my_table ...

14.8.2 Regular Expressions

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/replication-howto-masterbaseconfig.html

To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...

19.1.6 Replication and Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options.html

The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and variables for use on sources and replicas are covered separately, as are options and ...

7.6.4.3 Rewriter Query Rewrite Plugin Reference

https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-reference.html

Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...

15.2.15.1 The Subquery as Scalar Operand

https://dev.mysql.com/doc/refman/9.7/en/scalar-subqueries.html

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 almost anywhere a single column value or literal is legal, and you can expect it to have those ...

15.7.7.24 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/9.7/en/show-index.html

SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...

14.16.12 Spatial Aggregate Functions

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

Displaying 271 to 280 of 289 total results