Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
For each non-SELECT query (for example, INSERT, UPDATE, DELETE), you can find out how many rows were changed (affected) by calling mysql_affected_rows(). If mysql_field_count() returns zero, the statement returned no data (indicating that it was an ... Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...MySQL also supports the execution of a string containing multiple statements separated by semicolon (;) ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-function-reference.html
The following table summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 6.4, “C API Prepared Statement Function Descriptions”.
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-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...
https://dev.mysql.com/doc/c-api/8.4/en/null-mysql-store-result.html
The query returned no data (for example, it was an INSERT, UPDATE, or DELETE). If mysql_field_count() returns zero, the result is empty and the last query was a statement that does not return values (for example, an INSERT or a DELETE). It is ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
MySQL supports server-side full-text parser plugins with MyISAM and InnoDB. For introductory information about full-text parser plugins, see Full-Text Parser Plugins. A full-text parser plugin can be used to replace or modify the built-in full-text ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-28.html
(Bug #33461744) Running a PreparedStatement in the form of INSERT INTO ... It was because Connector/J did not recognize VALUE as an alias for VALUES in an INSERT statement, and mistook the VALUES() function as a VALUES clause for the statement.
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-32.html
(Bug #108814, Bug #34717205) When Connector/J looked for the presence of the ON DUPLICATE KEY UPDATE clause in prepared statements, it neglected the cases where the VALUES function was used without the VALUE(S) clause in INSERT statements. (Bug ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #38044940) A java.sql.Time instance created from a negative millisecond value, when inserted into a database via using a PreparedStatement, lost its fractional part of the seconds. (Bug #115845, Bug #36954268) Inserting unsigned big numbers ...