Search Results
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-loadable-function.html
For aggregate functions that work like SUM(), you must also provide the following functions: xxx_clear() Reset the current aggregate value but do not insert the argument as the initial aggregate value for a new group. You should not store a string ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.7/en/news-9-6-0.html
The following commands now grant INSERT and UPDATE ON to MySQL Router accounts: setup_router_account(): grants INSERT and UPDATE ON to new accounts. (Bug #38555376) When loading a dump into a server with the global system variable ... Note These ...
https://dev.mysql.com/doc/refman/9.7/en/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. With INSERT and REPLACE statements, where you would otherwise use SELECT *. TABLE is a DML statement which returns rows and columns of the ...
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 ...