Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
opened_tables Opened_tables ASYNC COUNTER The number of tables that have been opened prepared_stmt_count Prepared_stmt_count ASYNC GAUGE COUNTER The current number of prepared statements queries Queries ASYNC COUNTER The number of statements ... The ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential backups. Each differential backups includes all the changes made to the data since the last full backup ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
For SELECT queries, you retrieve the selected rows as a result set. Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling mysql_library_init().
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
uint64_t mysql_affected_rows(MYSQL *mysql) Description mysql_affected_rows() may be called immediately after executing a statement with mysql_real_query() or mysql_query(). It returns the number of rows changed, deleted, or inserted by the last ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-field-count.html
unsigned int mysql_field_count(MYSQL *mysql) Description Returns the number of columns for the most recent query on the connection. The normal use of this function is when mysql_store_result() returned NULL (and thus you have no result set pointer). In this case, you can call mysql_field_count() to determine whether mysql_store_result() should have produced a nonempty ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. The string in the from argument is encoded in hexadecimal format, with each character ...
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 ...