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/lock-instance-for-backup.html
Operations that modify InnoDB files that are not recorded in the InnoDB redo log are also blocked. PURGE BINARY LOGS should not be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of ...Executing the LOCK INSTANCE FOR BACKUP statement requires the BACKUP_ADMIN ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. Several SQL mode options are available to provide greater control over handling of bad ...The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
Applications that use UTF-8 data but require supplementary character support should use utf8mb4 rather than utf8mb3 (see Section 12.9.1, “The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)”). For example: mysqld ... The utf8mb3 character ...Expect utf8mb3 to be removed in a future major release of ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
If a column has only a small set of possible values, the data type is converted to ENUM. Note While a compressed table is read only, and you cannot therefore update or add rows in the table, DDL (Data Definition Language) operations are still valid.
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
Consider the following query: SELECT * FROM employee JOIN department ON employee.dept_no = department.dept_no WHERE employee.first_name = 'John' AND employee.hire_date BETWEEN '2018-01-01' AND '2018-06-01'; Suppose that the data set has these ... In ...This flag is enabled by default but can be disabled to suppress condition filtering (for example, if a particular query is found to yield better performance without ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Connector/J provides driver support for connecting to MySQL from Java applications using the standard Java Database Connectivity (JDBC) API. Connector/ODBC provides driver support for connecting to MySQL using the Open Database Connectivity (ODBC) ... MySQL Connectors provide connectivity to the MySQL server for client ...MySQL Connectors Oracle develops a number ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption.html
MySQL Enterprise Edition includes a set of encryption functions that expose OpenSSL capabilities at the SQL level. From MySQL 8.0.30, they are provided by a MySQL component component_enterprise_encryption. Note MySQL Enterprise Encryption is an ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-sql-modes.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. Is the mode dependent on the database or connection? A mode is not linked to a particular database. Does strict mode impact ...What is ...See Section 7.1.11, “Server SQL Modes”, for a complete list of available ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The format of the CREATE SERVER statement is: CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) The server_name is used in the connection string when creating a new FEDERATED table. For reference, the format ... If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the CONNECTION ...