Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
D data dictionary A set of tables, controlled by the InnoDB storage engine, that keeps track of InnoDB-related objects such as tables, indexes, and table columns. These terms are commonly used in information about the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined explicitly as dictionary-encoded columns. Minimizes the amount of data stored for string columns by ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
When a primary key is added to a table by the server, the column and key name is always my_row_id. For this reason, when enabling generated invisible primary keys in this way, you cannot create a table having a column named my_row_id unless the ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. column IS [NOT] NULL column IN (value_list) Each item in the value_list must be a constant, literal value. column BETWEEN constant1 AND ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
Tags are matched based on the tag or attribute name and the column name. User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. You can work around ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-syntax.html
If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE COLUMNS, see Section 26.2.3.1, “RANGE COLUMNS partitioning”. Similar to partitioning ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
SET column values that consist of multiple set members are specified with members separated by commas (,). For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/workbench/en/wb-image-editor.html
The Image Tab Use the Image tab of the image editor to perform the following tasks: Rename the image using the Name text box. To invoke the image editor, double-click an image object on an EER Diagram canvas. This opens the image editor docked at ...