intmysql_real_query(MYSQL *mysql, const char *stmt_str, unsigned long length)mysql_real_query() is a synchronous function. Its asynchronous counterpart ismysql_real_query_nonblocking(), for use by applications that require asynchronous communication with the server. SeeChapter 7,C API Asynchronous Interface.
mysql_real_query() executes the SQL statement pointed to bystmt_str, a stringlength bytes long. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or\g. If multiple-statement execution has been enabled, the string can contain several statements separated by semicolons. SeeSection 3.6.3, “Multiple Statement Execution Support”.
mysql_query() cannot be used for statements that contain binary data; you must usemysql_real_query() instead. (Binary data may contain the\0 character, whichmysql_query() interprets as the end of the statement string.) In addition,mysql_real_query() is faster thanmysql_query() because it does not callstrlen() on the statement string.
To determine whether a statement returns a result set, callmysql_field_count(). SeeSection 5.4.23, “mysql_field_count()”.
Commands were executed in an improper order.
The MySQL server has gone away.
The connection to the server was lost during the query.
An unknown error occurred.