PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/9.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/9.7/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They ...
https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/9.7/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...