Search Results
https://dev.mysql.com/doc/refman/8.4/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Besides the message output of MySQL Enterprise Backup to the stderr stream and the log file, progress and history of each backup are also logged into the mysql.backup_progress and mysql.backup_history tables on the backed-up servers (to skip ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-num-fields.html
unsigned int mysql_num_fields(MYSQL_RES *result) To pass a MYSQL* argument instead, use unsigned int mysql_field_count(MYSQL *mysql). You can get the number of columns either from a pointer to a result set or to a connection handler. You would use ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
int mysql_stmt_execute(MYSQL_STMT *stmt) Description mysql_stmt_execute() executes the prepared query associated with the statement handler. The currently bound parameter marker values are sent to server during this call, and the server replaces ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) Description mysql_stmt_fetch() returns the next row in the result set. It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
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 distributions. The audit_null.c and audit_null_variables.h source files in that directory implement an ...
https://dev.mysql.com/doc/connectors/en/connector-j-testing.html
The Connector/J source code repository or packages that are shipped with source code include an extensive test suite, containing test cases that can be executed independently. The test cases are divided into the following categories: Unit tests: ...
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. The method used to update indexes will vary from storage engine to storage engine, depending on the method ...