Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. The precise syntax and semantics depend ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
DROP TABLE and TRUNCATE TABLE statements on the table do not activate this trigger, because they do not use DELETE. CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. DROP [UNDO] TABLESPACE tablespace_name ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The ...
https://dev.mysql.com/doc/refman/8.4/en/fixed-point-types.html
(The precise behavior is operating system-specific, but generally the effect is truncation to the permissible number of digits.) . The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
TRUNCATE TABLE for a table closes all handlers for the table that were opened with HANDLER OPEN. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these columns: INDEX_ID An identifier for the index. Index identifiers are unique across all the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. NAME The name of the table, preceded by ...