Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
A session holding a WRITE lock can perform table-level operations such as DROP TABLE or TRUNCATE TABLE. For sessions holding a READ lock, DROP TABLE and TRUNCATE TABLE operations are not permitted. LOCK {TABLE | TABLES} tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. Options that can be used with ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
--force-if-open, -F Command-Line Format --force-if-open Read binary log files even if they are open or were not closed properly (IN_USE flag is set); do not fail if the file ends with a truncated event. Since the server may be in the process of ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-functions.html
Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Use TRUNCATE TABLE to empty a table, not DELETE FROM tbl_name. Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE and CREATE TABLE might be fastest. Many ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
In MySQL 8.4, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
If you wish to drop all data from all partitions while preserving the table definition and its partitioning scheme, use the TRUNCATE TABLE statement. (See Section 15.1.37, “TRUNCATE TABLE Statement”.) If you intend to change the partitioning of ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-binary-log-transaction-compression-stats-table.html
The statistics cover all transactions written to the binary log and relay log from the time the server was started or the table was truncated. This table shows statistical information for transaction payloads written to the binary log and relay ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The host_cache table has these indexes: Primary key on (IP) Index on (HOST) TRUNCATE TABLE is permitted for the host_cache table. Truncating the table flushes the host cache, which has the effects described in Flushing the Host Cache. The MySQL ...