PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For VARCHAR columns, trailing spaces in excess of the column ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The FILES table has these columns: FILE_ID For InnoDB: The tablespace ID, also referred to as the space_id or fil_space_t::id. For NDB: For a Disk Data undo log file, the auto-generated ID number of the log file group to which the log file belongs.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. “Record” and “row” are synonymous, as are “field” and “column.” The initial part of ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. For example (col1, col2, col3) specifies a multiple-column index with index keys consisting of values from col1, col2, and col3. Additionally, BLOB and TEXT ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a clustered index data structure contain the values of all columns in the row. The nodes of a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use different data types, subject to certain conditions. (This is true even if both ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
column->path In MySQL 5.7.9 and later, the -> operator serves as an alias for the JSON_EXTRACT() function when used with two arguments, a column identifier on the left and a JSON path (a string literal) on the right that is evaluated against the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. You can create ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
KEY takes only a list of zero or more column names. Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. Where no column name is specified as the partitioning key, the table's primary ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. For character and string columns, follow these guidelines: Use ...