Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
The following tables list Connector/ODBC API calls grouped by task: Table 5.5 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, ...For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
The following tables list Connector/ODBC API calls grouped by task: Table 7.1 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, ...For ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
This quickstart contains the following sections: AirportDB Requirements Download AirportDB Data Load AirportDB into DB system Load AirportDB into MySQL HeatWave Cluster Run AirportDB Queries Additional AirportDB Queries Unload AirportDB Tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular basis. The following sections in this topic describe how to update a vector store: ...This ensures that the responses generated by MySQL HeatWave GenAI are ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. If these tables are missing, the ...Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. The average value group size is related to table cardinality, ...For optimizer purposes, an important statistic is the average value group ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ... REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...