PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replace.html
If a generated column is replaced explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. The server recognizes but ignores the DELAYED keyword, ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. However, if such a column is updated explicitly, the only permitted value is DEFAULT. Also, only a single table in the view definition can be ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
Each grant table contains scope columns and privilege columns: Scope columns determine the scope of each row in the tables; that is, the context in which the row applies. Similarly, a db table row with Host, User, and Db column values of ... The ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE supports secondary indexes on virtual generated columns, which are supported by InnoDB. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for ...
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/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. The mysqldump utility provided in earlier releases uses incorrect syntax for generated column ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. (Bug #39701) Note A warning is generated if you try ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
If a generated column is updated explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
This is because the BLOB column value is logged, rather than the statement generating the data. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
xid values are supplied by the client, or generated by the MySQL server. Values generated by one TM must be different from values generated by other TMs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid ...