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/ndb-restore-to-different-version.html
Tables created in NDB 8.0 by default use the utf8mb4_ai_ci character set, which is not available in NDB 7.6 and earlier, and so cannot be read by an ndb_restore binary from one of these earlier versions. Due to changes in how the MySQL Server and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. A new row event is created for a modification that takes place in a different ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. An event may not be created from within a stored program. An event also may not ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
Batch mode can also be useful while you're developing a query, particularly for multiple-line statements or multiple-statement sequences. In the previous sections, you used mysql interactively to enter statements and view the results. If you want ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
Administration is restricted to authorized users who are granted special privileges so that only they can create and modify the dictionaries. This may include genetic sequences (long strings), test results stored in JSON format, and other data types. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_INDEX_CACHE table provides token information ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_INDEX_TABLE table provides information about ...