Search Results
https://dev.mysql.com/doc/internals/en/tracing-example.html
All traces have the same basic structure, but if a statement uses subqueries, there are several join preparations/optimizations/executions, subquery-specific transformations not shown here... The statement's execution is naturally made of "steps": ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
MySQL Workbench includes a plugin that generates PHP code with the mysqli extension. This tutorial shows how to generate code with the PDO_MySQL extension for PHP. $e->getMessage(); } """ % params mforms.Utilities.set_clipboard_text(text) ...You ...
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
Technically, a statement transaction can be viewed as a transaction which starts with a savepoint which MySQL maintains automatically, in order to make the effects of one statement atomic. Since MySQL supports pluggable storage engine architecture ... Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-synchronous-transactions.html
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 basic data operations (insert, update, read, and select) on this table using ...
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-introduction.html
The X DevAPI is implemented by MySQL Shell and MySQL Connectors that support X Protocol. For more background information and instructions on how to install and get started using X DevAPI, see Using MySQL as a Document Store. For quick-start ... This ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-statements.html
Default Value false Since Version 3.1.7 queryInterceptors A comma-delimited list of classes that implement 'com.mysql.cj.interceptors.QueryInterceptor' that intercept query executions and are able influence the results. This results in better ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
The Administration - Users and Privileges tab provides a list of all users and privileges that relate to an active MySQL server instance. To open the Administration - Users and Privileges tab: Establish a connection to an active MySQL server ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-exceptions-warnings.html
dumpQueriesOnException Should the driver dump the contents of the query sent to the server in the message for SQLExceptions? Default Value false Since Version 3.1.3 exceptionInterceptors Comma-delimited list of classes that implement the interface ...These classes will be instantiated one per 'Connection' instance, and all 'SQLException' exceptions thrown by the driver will be allowed to be intercepted by these interceptors, in a chained fashion, with the first class listed as the head of the ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, and UPDATE statements. We then create a new cursor, by default a MySQLCursor object, using ... Inserting or updating data is also done using the handler structure known as a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, and UPDATE statements. We then create a new cursor, by default a MySQLCursor object, using ... Inserting or updating data is also done using the handler structure known as a ...