mysql_query

mysql_query sends a null-terminated SQL string to the MariaDB server for execution, returning zero on success; use mysql_real_query for binary-safe operation.

Syntax

int mysql_query(MYSQL * mysql,
                const char * query);

Parameters

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

• query -a null terminated string containing the statement to be performed.

Description

Performs a statement pointed to by the null terminate string query against the database. Contrary to mysql_real_query(), mysql_query() is not binary safe.

Return Value

Returns zero on success, non zero on failure

For executing multi statements the statements within the null terminated string statements must be separated by a semicolon.

If your statement contains binary data you should use mysql_real_query() or escape your data with mysql_hex_string().

To determine if a statement returned a result set use the function mysql_num_fields().

See Also

• mysql_real_query()

• mysql_num_fields()

• mysql_hex_string()

• mysql_use_result()

• mysql_store_result()