MySQL :: MySQL 9.7 Reference Manual

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

Search Results

MySQL 9.7 Reference Manual

Displaying 41 to 44 of 44 total results

« Previous
1
2
3
4
5
Next »

10.3.5 Column Indexes

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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.11 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/9.7/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} ...