PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
The plugin communicates information to users by setting the table's message column. replacement The template that indicates how to rewrite statements matching the pattern column value. Load operations (performed by invoking the flush_rewrite_rules() ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/refman/5.7/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. If you have fixed-length columns that you access or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
INNODB_SYS_COLUMNS provides metadata about InnoDB table columns, equivalent to the information in the SYS_COLUMNS table in the InnoDB data dictionary. INNODB_SYS_FIELDS provides metadata about the key columns (fields) of InnoDB indexes, equivalent ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
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/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. This expression can be a column value, a function acting on one or more column values, or ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. Invalid values for ENUM and SET ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. In the definition of an integer column, it is an alias for NOT NULL ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Character Set Considerations The definition for character columns ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. The free-form ... This section describes issues that you may encounter when using the InnoDB memcached ...