Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-named-param.html
bool mysql_stmt_bind_named_param(MYSQL_STMT *stmt, MYSQL_BIND *binds, unsigned n_params, const char **names) Description mysql_stmt_bind_named_param() sets up unnamed and named (query attributes) bind parameters for prepared statements. This ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
The server plugin interface enables plugins to expose status and system variables using the status_vars and system_vars members of the general plugin descriptor. The status_vars member of the general plugin descriptor, if not 0, points to an array ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/using-own-protocol-trace-plugins.html
Note To use your own protocol trace plugins, you must configure MySQL with the WITH_TEST_TRACE_PLUGIN CMake option disabled because only one protocol trace plugin can be loaded at a time and an error occurs for attempts to load a second one. If you ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-overview.html
This topic describes how to prepare the data to use for a classification machine learning model. The classification use-case is to approve or reject loan applications for clients based on their personal and socioeconomic status, assets, ...