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/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and the CONNECTION_CONTROL plugin must be activated or the table contents are always empty. This table provides information about the ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this capability, two things must be true: Your system must be configured to support IPv6. Support for IPv6 in MySQL includes these ...IPv6 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-two-channels.html
First, the mysqld processes for the primary and secondary replication source servers must be started, followed by those for the primary and secondary replicas. In a more complete example scenario, we envision two replication channels to provide ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
Note All partitions of a partitioned table must have the same number of subpartitions; it is not possible to change the subpartitioning once the table has been created. If you (for example) wish to drop a partition and reorganize a table's remaining ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...First, as a preliminary condition, the replica checks whether statement-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
The rows in these tables for a given account indicate the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
This can be used to refer to a routine that is not in the current database. For example, to invoke a stored procedure p or function f that is associated with the test database, you can say CALL test.p() or test.f(). Multiple SELECT statements ... A ...A procedure is invoked using a CALL statement (see Section 15.2.1, “CALL Statement”), and can only pass back values using output ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
For subquery materialization to be used in MySQL, the optimizer_switch system variable materialization flag must be enabled. The optimizer uses materialization to enable more efficient subquery processing. The first time MySQL needs the subquery ...