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/create-function-loadable.html
IF NOT EXISTS prevents an error from occurring if there already exists a loadable function with the same name. It does not prevent an error from occurring if there already exists a built-in function having the same name. shared_library_name is the ... CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named ...(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
This enables you to control whether audited events are written to the audit log file based on the account from which events originate or event status. audit_log_connection_policy: Logging policy for connection events audit_log_statement_policy: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. To prevent execution of statements ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
When DNS SRV record lookup is used, clients generally must apply these rules for connection requests (there may be client- or connector-specific exceptions): The request must specify the full DNS SRV record name, with the service and protocol names ... In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to specify a name that indicates a service, protocol, and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Locking state is recorded in the account_locked column, which must have a value of 'N'. If the User column value is nonblank, the user name in an incoming connection must match exactly. It means that the user must connect without specifying a ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. The shared library must be located in the MySQL server plugin directory, the ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in ...A DELETE statement can start with a WITH clause to define common table expressions accessible within the ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
If VCPU is given, the attribute value is a list of comma-separated CPU numbers or ranges: Each number must be an integer in the range from 0 to the number of CPUs − 1. If a CPU number is an integer outside the permitted range or is not an integer, ...The VCPU attribute indicates the CPU affinity; that is, the set of virtual CPUs the group can use: If VCPU is not given, the resource group has no CPU affinity and can use all available ... CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
timeout must be greater than or equal to 0; when running in strict SQL mode, a negative timeout value is immediately rejected with an error (ER_WRONG_ARGUMENTS); otherwise the function returns NULL, and raises a warning. As such, the GTID sets must ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
Prior to MySQL 8.0.13, selecting from the KEYWORDS table with no default database selected produced an error. This file can be found in the sql directory under the build directory. This file may be useful for applications that require a static ...