Search Results
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/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as filters for finding relevant tables ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
\! ls -l data/test/big_table.ibd CREATE TABLE key_block_size_4 LIKE big_table; ALTER TABLE key_block_size_4 key_block_size=4 row_format=compressed; INSERT INTO key_block_size_4 SELECT * FROM big_table; commit; -- Check how much space is needed for a ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
It outputs the three INSERT statements following USE test, but not the three INSERT statements following USE db2. mysqlbinlog --database=db2 does not output the first two INSERT statements because there is no default database. It does not output the ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. When you insert a value of NULL (recommended) or 0 into ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
The MyISAM storage engine supports concurrent inserts to reduce contention between readers and writers for a given table: If a MyISAM table has no free blocks in the middle of the data file, rows are always inserted at the end of the data file. In ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...