Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-remove.html
mysql-py> db.countryinfo.remove("true").limit(1) Remove the Last Document in an Order The following example removes the last document in the countryinfo collection by country name. You can use the remove() method to delete some or all documents ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-delete.html
The X DevAPI provides additional methods to use with the delete() method to filter and order the records to be deleted. You can use the delete() method to remove some or all records from a table in a database. Delete Records Using Conditions The ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
The order of the column names indicates how to match data file columns with table columns. The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD ...
https://dev.mysql.com/doc/refman/8.4/en/null-values.html
For sorting with ORDER BY, NULL values sort before other values for ascending sorts, after other values for descending sorts. The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
(For information about the order in which option files are used, see Section 6.2.2.2, “Using Option Files”.) If the file does not exist or is otherwise inaccessible, an error occurs. Most MySQL programs that support option files handle the ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
To provide a hint about the table join order, use optimizer hints; see Section 10.9.3, “Optimizer Hints”. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
MySQL's partitioning implementation treats NULL as being less than any non-NULL value, just as ORDER BY does. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
Unlike the case with partitions defined by range, list partitions do not need to be declared in any particular order. List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...