Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. PARTITION_EXPRESSION The expression for the partitioning function used ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
If the flag is on, invisible indexes remain invisible but the optimizer takes them into account for execution plan construction. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
If the data types of corresponding result columns do not match, the types and lengths of the columns in the result take into account the values retrieved by all of the query blocks. Result Set Column Names and Data Types Set Operations with TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. A non-identifying relationship: identified by a broken (dashed) line between tables Create or drag and drop the tables that you wish to connect. In ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. You have seen how to create MySQL DDL code from an ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. You have seen how to create MySQL DDL code from an ...
https://dev.mysql.com/doc/internals/en/event-flags.html
This flag should be set for any event that does not need to have the default database set to function correctly, such as CREATE DATABASE and DROP DATABASE. Event headers for v3 format and up contain event flags in the two flag bytes at position ...