# mysql\_thread\_id

## Syntax

```c
unsigned long mysql_thread_id(MYSQL * mysql);
```

* `mysql` - a mysql handle, which was previously allocated by [mysql\_init()](mysql_init) or [mysql\_real\_connect()](mysql_real_connect).

## Description

The `mysql_thread_id()` function returns the thread id for the current connection.

{% hint style="info" %}
The current connection can be killed with [mysql\_kill()](mysql_kill). If reconnect option is enabled the thread id might change if the client reconnects to the server.
{% endhint %}

{% hint style="info" %}
Note that connector will return only the first 32connectionsbits value. If your database might expect to create more than 4.3 billion connections without a restart, it's better to query 'select `CONNECTION_ID()`'
{% endhint %}

## See also

* [mysql\_kill()](mysql_kill)
* [mysql\_options()](mysql_options)

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