Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. These rows have the country and products columns set to NULL. This row has the year, country, and ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. In other words, every unique key on the table must ...
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/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/internals/en/binlog-row-image.html
Status of this subsection: finished, not reviewed, not fully implemented 2009-10-21 The sets of columns recorded in the BI and AI are determined by the value of binlog_row_image. To specify the sets of columns, we define the PKE (for Primary Key ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. It then reads the columns back and extracts the data from them using local functions. See Section 2.5.15, “Common Files ...