Search Results
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/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/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/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/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 ...When you are ready to conduct long-term testing and put compressed tables into production, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” for ways to verify the effectiveness of those choices under real-world ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
Rows are grouped into events smaller than this size if possible. 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 ...
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/create-table.html
When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. INSERT_METHOD If you want to insert data into a MERGE table, you must specify with INSERT_METHOD the table into ...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 ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
That is, you can insert rows into a MyISAM table at the same time other clients are reading from it. The MyISAM storage engine supports concurrent inserts to reduce contention between readers and writers for a given table: If a MyISAM table has no ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
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.