Search Results
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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-use-result.html
The C API gives the error Commands out of sync; you can't run this command now if you forget to do this! You may not use mysql_data_seek(), mysql_row_seek(), mysql_row_tell(), mysql_num_rows(), or mysql_affected_rows() with a result returned from ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-26.html
Version 8.0.26 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
X DevAPI: Added the setSavepoint(), rollbackTo(), and releaseSavepoint() methods to the Session interface to support the SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT statements. Users can still set useInformationSchema to false; but for ... Version 8.0.9 Release Candidate is the first release candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations-ml-explain-table.html
mysql> SELECT * FROM table_name LIMIT N; The following example queries the top three rows of the output table. mysql> SELECT * FROM table_name LIMIT N; The following example queries the top three rows of the output table. ML_EXPLAIN_TABLE explains ...