PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. ERROR 1051 (42S02): Unknown ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
Here is a simple example that associates a trigger with a table, to activate for INSERT operations. The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Tables can be converted from utf8mb3 to utf8mb4 by using ALTER TABLE. Otherwise, you should be able to convert your tables from utf8mb3 to utf8mb4 without problems, using ALTER TABLE as described previously. In terms of table content, conversion ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-basics.html
Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Note This needs to be done only for ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ...Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
Resource Group Elements These capabilities provide the SQL interface for resource group management in MySQL: SQL statements enable creating, altering, and dropping resource groups, and enable assigning threads to resource groups. The Information ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...