Search Results
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. Just that happens in the preceding ...If one session has a shared or exclusive lock on record R in an index, another session cannot insert a new index record in the gap immediately before R in the index ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values into the column that differ only in number of trailing pad bytes results in a duplicate-key ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
If the insert exceeds this size, it is broken into multiple packets and the rollback problem can occur. Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: After establishing a connection to a MySQL Server instance, a new collection that ... Working with collections of documents is straightforward when using X ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-writing.html
After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called and the BLOB is inserted into the file table. To write a file to a database, we need to convert the file to a byte array, then use the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html
After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called and the BLOB is inserted into the file table. To write a file to a database, we need to convert the file to a byte array, then use the ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Innodb_system_rows_inserted The number of rows inserted into InnoDB tables belonging to system-created schemas. Delayed_errors This status variable is deprecated (because DELAYED inserts are not supported); expect it to be removed in a future ...