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/enterprise-encryption-installation.html
To install the component, issue an INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
This column is reserved for future use, in case new error conditions must be reported, and if preserving the backward compatibility and structure of the host_cache table is required. While HOST_VALIDATED is NO, DNS resolution is attempted for each ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance_schema_metadata_lock_lost The number of metadata locks that could not be instrumented in the metadata_locks table. This can be nonzero if the value of performance_schema_max_metadata_locks is too small. Performance Schema status ...For ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...For ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Just edit your script to correct the error, then tell mysql to execute it again. In the previous sections, you ...Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. A database in MySQL is implemented as a directory containing files that correspond to tables in the database. If a database name contains special characters, the name for ...create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... ANALYSE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...This ...