MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 261 to 270 of 272 total results

19.1.6 Replication and Binary Logging Options and Variables

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

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

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 ...

14.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html

This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

B.3.4.2 Problems Using DATE Columns

https://dev.mysql.com/doc/refman/8.0/en/using-date.html

You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...

8.4.3 The Password Validation Component

https://dev.mysql.com/doc/refman/8.0/en/validate-password.html

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...

Displaying 261 to 270 of 272 total results