PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, mysqldump, and mysqlpump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 rows. Scalar or column subqueries return a single value or a column of values. A row subquery is ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
where_condition is an expression that evaluates to true for each row to be selected. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
Most of the examples show SET statements that use keyword syntax (for example, GLOBAL or SESSION), but the principles are also true for statements that use the corresponding modifiers (for example, @@GLOBAL. variable: { user_var_name | param_name | ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. From MySQL 8.0.22, use SHOW REPLICA STATUS in place of SHOW SLAVE STATUS, which is deprecated from that ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
(This is also true if the InnoDB table is partitioned.) Avg_row_length The average row length. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
This is true whether the SQLSTATE value is specified directly in the SIGNAL statement or in a named condition referred to in the statement. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client.
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
Where that is true, those descriptions take precedence over the general discussion here. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
This remains true if the privileges needed to create the object are revoked from the account of the user who created it. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
This is true even for strings that are preceded by an introducer that indicates a different character set, as discussed in Section 12.3.6, “Character String Literal Character Set and Collation”. A string is a sequence of bytes or characters, ...