mysql_send_query − sends a SQL statement without waiting for server reponse
#include <mysql.h> int mysql_send_query(MYSQL * mysql, const char *query, unsigned long length);
Sends a statement to the server, without waiting for the Server OK packet and/or resultset.
• |
mysql − a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). | ||
• |
query − SQL statement | ||
• |
length − length of the SQL statement |
• |
The OK and result set package need to be retrieved by mysql_read_query_result(3) function | ||
• |
mysql_send_query() can be used for semi asynchronous operation. While the function itself is blocking, an event driven application can do other tasks until result set is available. |
For an example how to use ’mysql_send_query()` in an event driven model, please check Jan Kneschke’s article “Async MySQL Queries with C−API” (https://jan.kneschke.de/projects/mysql/async-mysql-queries-with-c-api/).
• |
<mysql_real_query> |
|||
• |
<mysql_read_query_result> |