PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
If the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled, you can store 0 in AUTO_INCREMENT columns as 0 without generating a new sequence value. STORAGE For NDB tables, it is possible to specify whether the column is stored on disk or in memory by using a ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
As of MySQL 8.0.22, CREATE USER fails with an error if any account to be created is named as the DEFINER attribute for any stored object. (That is, the statement fails if creating an account would cause the account to adopt a currently orphaned ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Different storage engines represent data types and store raw data differently. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. DATETIME is packed more efficiently, requiring 5 rather ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. In general, the rules governing event names are the same as those for names of stored routines. The ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This global parameter can be set only in the [ndbd default] section, and defines the number of fragment replicas for each table stored in the cluster. Warning Setting NoOfReplicas to 1 means that there is only a single copy of all ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. A key stored in the keyring by a given user can be manipulated later only by the same user. That is, ...MySQL Server also includes an SQL interface for keyring key management, implemented as a set of general-purpose functions that access the capabilities provided by the internal keyring ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Note Clauses for random password generation, password verification, and secondary passwords apply only to accounts that use an authentication plugin that stores credentials internally to MySQL. Plugin names are stored in the plugin column of the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
An ndbd or ndbmtd process, which stores one or more fragment replicas—that is, copies of the partitions (discussed later in this section) assigned to the node group of which the node is a member. A node group consists of one or more nodes, and ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
Now, any rows whose store_id column value is greater than or equal to 16 (the highest value defined) are stored in partition p3. At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE ...