Search Results
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
The column descriptions indicate the corresponding CHANGE REPLICATION SOURCE TO options from which the column values are taken, and the table given later in this section shows the correspondence between replication_connection_configuration columns ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...This occurs because the order in which the rows are numbered depends on the specific storage engine used for the table and the order in which the rows were ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. Creating a table having such columns with an explicit ...Of ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. For example, in a table containing information about people, you would not create a primary key on ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
The following figure shows an example of the layout with the PRIMARY index of the customer table selected and both the index columns and index options shown. Click an index name to display the Index Columns section with information about the ... The ...
https://dev.mysql.com/doc/internals/en/myisampack.html
When starting to analyze the existing uncompressed data, it collects distinct column values up to a limit of 8KB. If there are more, it falls back to byte value compression for this column. This means also that myisampack may use different ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
The BINARY operator in expressions differs in effect from the BINARY attribute in character column definitions. For a character column defined with the BINARY attribute, MySQL assigns the table default character set and the binary (_bin) collation ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
The table has the following columns (with the corresponding Performance Schema firewall_groups table having similar but not necessarily identical columns): NAME The group profile name. The table has the following columns (with the corresponding ...