PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A number of features supported by other storage engines are not supported for NDB tables. A ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features to be supported or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules.html
For statements affecting databases only (that is, CREATE DATABASE, DROP DATABASE, and ALTER DATABASE), database-level options always take precedence over any --replicate-wild-do-table options. You should not use these options to control which ... If ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a given UTC value. Temporal values are ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a (scheduled) event is an object whose statements are executed in response to the passage of a specified time ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html
This variable has the following possible values: Table 20.1 group_replication_ssl_mode configuration values Value Description DISABLED Establish an unencrypted connection (the default). REQUIRED Establish a secure connection if the server supports ... Secure sockets can be used for group communication connections between members of a ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and altered with the ALTER PROCEDURE and ALTER FUNCTION statements (see Section 15.1.7, ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
This applies to the ALTER USER, CREATE USER, and SET PASSWORD statements. Note For statements that assign or modify account passwords (ALTER USER, CREATE USER, and SET PASSWORD), the validate_password capabilities described here apply only to ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...