Search Results
https://dev.mysql.com/doc/refman/9.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/9.7/en/workbench.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. MySQL Workbench provides a graphical tool for working with MySQL servers and ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-update.html
There are two types of operations to bring your backup data up-to-date: Apply-log Operation After a backup job was first completed, the backup data might not be in a consistent state, because data could have been inserted, updated, or deleted while ...During a backup, mysqlbackup also copies the accumulated InnoDB log to a file called ...
https://dev.mysql.com/doc/mysql-router/9.7/en/router-read-write-splitting-statements.html
The following DML: CALL, INSERT, UPDATE, DELETE, REPLACE, IMPORT TABLE, LOAD DATA, LOAD XML, WITH...UPDATE/DELETE. The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-extension-createresult-return.html
The data can be either a dictionary, for a single result, or a list of dictionaries, for multiple results. Single Result Multiple Result Single Result The data dictionary for a single result must be a dictionary and include the following: ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-interactive-code-execution.html
The rules for when you need to call execute() or not are as follows: When using MySQL Shell in this way, calling execute() becomes optional on: Collection.add() Collection.find() Collection.remove() Collection.modify() Table.insert() Table.select() ... The default mode of MySQL Shell provides interactive execution of database operations that you type at the command ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-num-rows.html
For statements such as INSERT, UPDATE, or DELETE, the number of affected rows can be obtained with mysql_affected_rows(). uint64_t mysql_num_rows(MYSQL_RES *result) Description Returns the number of rows in the result set. The use of ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-fetch.html
(This example expects to retrieve the two rows inserted by the example shown in Section 6.4.11, “mysql_stmt_execute()”.) The mysql variable is assumed to be a valid connection handler. int mysql_stmt_fetch(MYSQL_STMT *stmt) Description ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-field-count.html
This value is zero for statements such as INSERT or DELETE that do not produce result sets. unsigned int mysql_stmt_field_count(MYSQL_STMT *stmt) Description Returns the number of columns for the most recent statement for the statement handler.