Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
SELECT FROM memory_table may insert a different set of rows on the source and replica. When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
Even if free space displays as 0, it may be possible to insert rows as long as new extents need not be allocated. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/extending-mysql/8.4/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/connector-j/en/news-8-0-29.html
(Bug #106065, Bug #33726184) When inserting BigDecimal values into a database using rewritable server-side prepared statements with cursor-based fetching, the values suffered precision loss. (Bug #104349, Bug #33563548) When the connection property ... Version 8.0.29 is the latest General Availability release of the 8.0 series of MySQL ...
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 ...