Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. For example: CREATE TABLE test (blob_col BLOB, ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
Briefly, it contains two kinds of information: Statement information, such as the number of conditions that occurred or the affected-rows count. For a statement that produces three conditions, the diagnostics area contains statement and condition ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
READ syntax fetches a row where the index specified satisfies the given values and the WHERE condition is met. READ syntax fetches a row from the table in index order that matches the WHERE condition. READ syntax fetches a row from the table in ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
The USE INDEX (index_list) hint tells MySQL to use only one of the named indexes to find rows in the table. In other words, a table scan is used only if there is no way to use one of the named indexes to find rows in the table. To affect only the ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-locks.html
If a transaction holds an exclusive lock on a given row, all other locks on that row have the same transaction ID. When the detail column contains a * (asterisk character), this means that this lock is the first holding lock in the affected row's ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
If a transaction has an exclusive lock on a given row, all other locks on that row have the same transaction ID. The detail column indicates whether this lock is the first holding lock in the affected row's lock queue, in which case it contains a * ... The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--replace, -r Command-Line Format --replace The --replace and --ignore options control handling of input rows that duplicate existing rows on unique key values. If you specify --replace, new rows replace existing rows that have the same unique key ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...