Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-rotate-log.html
rotate log [{--hosts=|-h }host_list] [site_name] host_list: host[,host[,...]] Rotate mcmd logs for the connected MySQL Cluster Manager agent, for agents running on certain hosts, or for agents on all hosts in a management site.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
You can comment out a line by inserting a leading hash character (#). Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
Otherwise, it sends an okay status and the number of rows changed, deleted, or inserted. To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on ...
https://dev.mysql.com/doc/c-api/8.4/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/8.4/en/mysql-stmt-bind-param.html
bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_prepare(). The client library expects the ...
https://dev.mysql.com/doc/c-api/8.4/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/8.4/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.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-num-rows.html
For statements such as INSERT, UPDATE, or DELETE, the number of affected rows can be obtained with mysql_stmt_affected_rows(). uint64_t mysql_stmt_num_rows(MYSQL_STMT *stmt) Description Returns the number of rows in the result set. The use of ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-prepare.html
For example, they are permitted in the VALUES() list of an INSERT statement (to specify column values for a row), or in a comparison with a column in a WHERE clause to specify a comparison value. int mysql_stmt_prepare(MYSQL_STMT *stmt, const char ...