Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\ibuf (INSERT BUFFER) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- ibuf0ibuf.c Insert Buffer / 91,397 Insert buffer The words "Insert Buffer" mean not "buffer used for INSERT" but ... The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Topics in this section: Prepared Statements with Single Round-Trip Streaming Inserts SQL with Multiple Resultsets Inserting CRUD Data in a Batch Cross-Collection Update and Delete Prepared Statements with Single Round-Trip In the MySQL ...Figure ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the third and final phase, the sorted entries are inserted into the B-tree; this final phase is multithreaded. Prior to the ...This ...
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. The X DevAPI SQL CRUD functions allow you to work ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
For information about the efficiency of INSERT versus LOAD DATA and speeding up LOAD DATA, see Section 10.2.5.1, “Optimizing INSERT Statements”. If there are BEFORE INSERT or AFTER INSERT triggers for the table, they are activated before or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. For statements that insert rows, the behavior differs in that failure to find a suitable partition causes the statement to fail.
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
This section contains simple examples of the use of Connector/ODBC with ADO, DAO and RDO. 5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of ...