Search Results
https://dev.mysql.com/doc/internals/en/x-protocol-expect-expectations.html
Example: Mysqlx.Expect::Open([+gtid_wait_less_than_ms = 1000]) Mysqlx.Expect::Close() sql_stateless Fail any message that executes stateful statements like: temporary tables user variables session variables stateful functions (INSERT_ID(), ...Assume ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
Note The MySQL C/S provided some of this information via functions: Parameter Information Functions CURRENT_SCHEMA DATABASE() GENERATED_INSERT_ID LAST_INSERT_ID() ROWS_FOUND FOUND_ROWS() ROWS_AFFECTED ROW_COUNT() SESSION_ID CONNECTION_ID() . Global ...
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/mysql-monitor/8.0/en/memory-usage-advisors-ref.html
A low hit rate may indicate not enough memory is allocated to the cache, identical queries are not being issued repeatedly to the server, or that the statements in the query cache are invalidated too frequently by INSERT, UPDATE, or DELETE ...It is ...
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/8.4/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/8.4/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 ...