Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. If ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | +--------------------------------+------------------------------+ | XXX-XXX-XXX | XXXXXXXXX | +--------------------------------+------------------------------+ mysql> SELECT mask_canada_sin('909'); ERROR 1123 (HY000): Can't initialize function 'mask_canada_sin'; Argument 0 is too ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
12 Warning: level, code, message 13 Error: error number, error message Although this example uses the ConsoleTraceListener, any of the other standard listeners can be used. This value is defined by the MySqlTraceEventType public enum contained in ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
null_audit_abort_value: The custom error code to use when an event is aborted. It is also possible to specify a custom error code by setting the null_audit_abort_value variable to the value that the notification routine should return: SET ...Audit ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/ndbapi_simple_dual/main.cpp. This example demonstrates synchronous transactions and connecting to multiple clusters in a single ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-synchronous-transactions.html
This example illustrates the use of synchronous transactions in the NDB API. It first creates a database ndb_examples and a table api_simple (if these objects do not already exist) using the MySQL C API with an SQL node, then performs a series of ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Figure 19.1 Using Replication to Improve Performance During Scale-Out If the part of your code that is responsible for database access has been properly abstracted/modularized, converting it to run with a replicated setup should be very smooth and ... You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable ...