Search Results
Displaying 931 to 940
of 948 total results
- « Previous
- 92
- 93
- 94
- 95
- Next »
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/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/9.7/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/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-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/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.
https://dev.mysql.com/doc/c-api/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-store-result.html
mysql_store_result() returns NULL if the statement did not return a result set (for example, if it was an INSERT statement), or an error occurred and reading of the result set failed. MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note ...
Displaying 931 to 940
of 948 total results
- « Previous
- 92
- 93
- 94
- 95
- Next »