mysql_send_query − sends a SQL statement without waiting for server response
#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”.
|
• |
mysql_real_query |
|||
|
• |
mysql_read_query_result |