Search Results
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 ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.57 load(T) Parameter Description instance the instance to load return the instance See Also found(java.lang.Object) 4.3.1.22.17 makePersistent(T) public abstract T makePersistent(T instance); Insert the instance into the database. Table 4.58 ...Inserts, deletes, loads, and updates are sent to the back ...Session extends ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...