int mysql_query(MYSQL *mysql, const char
*query)
Description
Executes the SQL query pointed to by the null-terminated
string query
. 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
Sección 24.2.9, “Tratamiento por parte de la API C de la ejecución de múltiples
consultas”.
mysql_query()
cannot be used for queries
that contain binary data; you should use
mysql_real_query()
instead. (Binary data
may contain the '\0
' character, which
mysql_query()
interprets as the end of the
query string.)
If you want to know whether the query should return a result
set, you can use mysql_field_count()
to
check for this. See Sección 24.2.3.20, “mysql_field_count()
”.
Return Values
Zero if the query was successful. Non-zero if an error occurred.
Errors
CR_COMMANDS_OUT_OF_SYNC
Commands were executed in an improper order.
CR_SERVER_GONE_ERROR
The MySQL server has gone away.
CR_SERVER_LOST
The connection to the server was lost during the query.
CR_UNKNOWN_ERROR
An unknown error occurred.
Ésta es una traducción del manual de referencia de MySQL, que puede encontrarse en dev.mysql.com. El manual de referencia original de MySQL está escrito en inglés, y esta traducción no necesariamente está tan actualizada como la versión original. Para cualquier sugerencia sobre la traducción y para señalar errores de cualquier tipo, no dude en dirigirse a mysql-es@vespito.com.