PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). HELP 'search_string' The HELP statement returns online information from the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-firewall-table-reference.html
Table 28.9 INFORMATION_SCHEMA Firewall Tables Table Name Description Deprecated MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles 8.0.26 MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists 8.0.26 .
https://dev.mysql.com/doc/refman/8.0/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_users system table that provides persistent storage of firewall data; see MySQL Enterprise ...It lists names and operational modes of registered firewall account ...As of MySQL 8.0.26, ...