Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
NdbBlob::setValue() Description This method is used to prepare for inserting or updating a blob value. Signature int setValue ( const void* data, Uint32 bytes ) Parameters This method takes the two parameters listed here: The data that is to be ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
Currently, all INSERT, DELETE, and UPDATE events—as well as all attribute changes—are sent to the API, even if only some attributes have been specified. In the NDB Cluster replication code, duplicate primary keys on INSERT operations are ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/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/x-devapi-userguide-shell-python/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/connector-j/en/connector-j-usagenotes-statements.html
If you do not know ahead of time whether the SQL statement will be a SELECT or an UPDATE/INSERT, then you can use the execute(String SQL) method. This method will return true if the SQL query was a SELECT, or false if it was an UPDATE, INSERT, or ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-check-constraints.html
CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. CHECK constraints are evaluated for INSERT IGNORE, UPDATE IGNORE, LOAD DATA ... CREATE TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or ...Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: ...