MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 45 of 45 total results

« Previous
1
2
3
4
5
Next »

https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html

Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...

10.3.5 Column Indexes

https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html

The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...

12.6 Error Message Character Set

https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html

This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...

B.3.4.1 Case Sensitivity in String Searches

https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html

For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...

15.1.9 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...