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/update.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
These functions permit the server's list of version tokens to be created, changed, removed, and inspected: version_tokens_set() completely replaces the current list and assigns a new list. Before using Version Tokens, install it according to the ...
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). The optimizer ... InnoDB automatically extends each secondary index by appending the primary key columns to ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
You can create a my.cnf file and specify startup options for the engines that you plan to use. For example, if the data directory is /usr/local/mysql/var, use this command: $> ls -la /usr/local/mysql/var If the data directory or its files or ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
The server handles entries in the host cache like this: When the first TCP client connection reaches the server from a given IP address, a new cache entry is created to record the client IP, host name, and client lookup validation flag. Only ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
Decreasing this parameter online after any tables have been created or modified with DefaultHashMapSize equal to 3840 is not currently supported. Time elapsed during node connection attempts is not taken into account when calculating elapsed time ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-disk-data.html
Extents require sufficient DiskPageBufferMemory; you must reserve enough for this parameter to account for all memory used by all extents (number of extents times size of extents). Disk data objects are subject to the following maximums and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
These Performance Schema tables expose attribute information: session_account_connect_attrs: Connection attributes for the current session, and other sessions associated with the session account session_connect_attrs: Connection attributes for all ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...