PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...
https://dev.mysql.com/doc/refman/8.0/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
Data types The MEDIUMINT, SET, and ENUM data types, and the various BLOB and TEXT data types. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
binlog_format Command-Line Format --binlog-format=format Deprecated 8.0.34 System Variable binlog_format Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value ROW Valid Values MIXEDSTATEMENTROW This system variable ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
SET and ENUM are treated similar to VARCHAR; the result is VARCHAR. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This exclusion extends to JSON, BIT, and ENUM columns as well. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for ...