# mysql\_query

## Syntax

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

* `mysql` - a mysql handle, which was previously allocated by [mysql\_init()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_init) or [mysql\_real\_connect()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/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()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_query), mysql\_query() is not binary safe.

Returns zero on success, non zero on failure

{% hint style="info" %}
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()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_query) or escape your data with [mysql\_hex\_string()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_hex_string).

To determine if a statement returned a result set use the function [mysql\_num\_fields()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_num_fields).
{% endhint %}

## See also

* [mysql\_real\_query()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_query)
* [mysql\_num\_fields()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_num_fields)
* [mysql\_hex\_string()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_hex_string)
* [mysql\_use\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_use_result)
* [mysql\_store\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_store_result)

{% @marketo/form formId="4316" %}