int mysql_query(MYSQL *mysql, const char
*stmt_str)
Description
Executes the SQL statement pointed to by the null-terminated
string stmt_str
. Normally, the string must
consist of a single SQL statement and you should not add a
terminating semicolon (“;
”) or
\g
to the statement. If multiple-statement
execution has been enabled, the string can contain several
statements separated by semicolons. See
Section 17.6.12, “C API Support for Multiple Statement Execution”.
mysql_query()
cannot be used for
statements that contain binary data; you must use
mysql_real_query()
instead.
(Binary data may contain the
“\0
” character, which
mysql_query()
interprets as the
end of the statement string.)
If you want to know whether the statement should return a result
set, you can use
mysql_field_count()
to check for
this. See Section 17.6.3.22, “mysql_field_count()
”.
Return Values
Zero if the statement was successful. Nonzero if an error occurred.
Errors
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.
User Comments
Add your own comment.