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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-elements.html
Tables in the mysql system database provide backing storage of firewall data for persistence of profiles across server restarts. Stored procedures perform tasks such as registering firewall profiles, establishing their operational mode, and managing ... MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on the registered firewall profiles, renders a decision whether to execute or reject each ...
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. For FLOAT, the SQL standard permits an optional specification of the precision (but not the range of the exponent) in bits following the keyword FLOAT in parentheses, that is, ...