Search Results
https://dev.mysql.com/doc/connectors/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/internals/en/guided-tour-majordir-myisam.html
The only one that's a little hard to find is the program for inserting rows, which we've called mi_write.c instead of mi_insert.c. We will begin by mentioning that myisam is one of what we call the MySQL storage engine directories. But the files in ...
https://dev.mysql.com/doc/internals/en/innodb-page-example.html
02 E1 PAGE_LAST_INSERT The last record was inserted at location 02E1, not shown, within the page. 00 0F PAGE_N_DIRECTION The last 15 (hexadecimal 0F) inserts were all done "to the right" because I was inserting in ascending order. For this example, ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
PAGE_DIRECTION and PAGE_N_DIRECTION: It's useful to know whether inserts are coming in a constantly ascending sequence. PAGE_HEAP_TOP and PAGE_FREE and PAGE_LAST_INSERT: Warning: Like all record pointers, these point not to the beginning of the ...
https://dev.mysql.com/doc/internals/en/innodb-user-records.html
In the User Records part of a page, you'll find all the records that the user inserted. There are two ways to navigate through the user records, depending whether you want to think of their organization as an unordered or an ordered list. If you ...
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/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 ...