Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. A transaction that performs only INSERT operations on regular tables requires a single undo ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
One of these is to modify the table definition before importing it into the Cluster database. Then modify the table definitions as just described and import the file into the SQL node of the cluster like this: $> mysql world < /tmp/world.sql If you ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
You can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ODBC Date and Time Literals String and Numeric ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and Sorting Character Set Conversion Lettercase Conversion Trailing Space Handling in Comparisons Trailing Space ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-csharp.html
The following sample creates a table my_odbc_net and demonstrates its use in C#. { for (int i=0; i < MyOdbcException.Errors.Count; i++) { Console.Write("ERROR #" + i + "\n" + "Message: " + MyOdbcException.Errors[i].Message + "\n" + "Native: " + ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
JSON_INSERT(json_doc, path, val[, path, val] ...) Inserts data into a JSON document and returns the result. If a path identifies an array element, the corresponding value is inserted at that element position, shifting any following values to the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
In this example, we perform two inserts in the same transaction using NdbTransaction::execute(NoCommit). In NDB API applications, there are two types of failures to be taken into account: Transaction failures: If nonpermanent, these can be handled ... This program demonstrates handling errors and retrying failed transactions using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
mysql> INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) -> ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b); Important This usage is deprecated, and subject to removal in a future release of MySQL. The MAC address of an interface is taken into account ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
If the request is, for example, an INSERT statement, the Performance Schema refines the instrument name from statement/abstract/Query to statement/sql/insert, which is the final name. If the request is, for example, an INSERT statement, the ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
Specifically: If the slave has a uniqueness constraint (PK or UK), then uniqueness must be guaranteed before a row is inserted on the slave. If a column only exists on the slave (or if application-specific logic ensures that only NULL values are ...