Search Results
https://dev.mysql.com/doc/refman/9.7/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-cluster-user-accounts.html
Schema specific privileges for mysql_innodb_cluster_metadata.*, mysql_innodb_cluster_metadata_bkp.*, and mysql_innodb_cluster_metadata_previous.* are ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, ... Configuring InnoDB Cluster Administrator Accounts Manually Internal User Accounts Created by InnoDB Cluster Resetting Recovery Account Passwords The member servers in an InnoDB Cluster make use of three types of user ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json.html
The utility checks that the supplied JSON documents are well-formed and inserts them into the target database, removing the need to use multiple INSERT statements or write scripts to achieve this task. MySQL Shell's JSON import utility ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/c-api/9.7/en/c-api-basic-interface-usage.html
For each non-SELECT query (for example, INSERT, UPDATE, DELETE), you can find out how many rows were changed (affected) by calling mysql_affected_rows(). If mysql_field_count() returns zero, the statement returned no data (indicating that it was an ... Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...MySQL also supports the execution of a string containing multiple statements separated by semicolon (;) ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-prepared-statement-function-reference.html
The following table summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 6.4, “C API Prepared Statement Function Descriptions”.