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/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, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-flow-control.html
When some members lag behind the rest of the group, reads on such members may externalize very old data. Depending on why the member is lagging behind, other members in the group may have to save more or less of the replication context to be able to ... MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
A replication group is a set of servers, each of which has a complete copy of the data (a shared-nothing replication scheme), which interact with each other through message passing. These are very powerful properties that translate into very useful ...The communication layer provides a set of guarantees such as atomic message and total order message ...