mysql_thread_id()函数

函数原型：

unsigned long mysql_thread_id(MYSQL *mysql)

描述：

Returns the thread ID of the current connection. This value can be used as an argument to mysql_kill() to kill the thread.

获取当前连接线程的id，该值可以作为mysql_kill()的参数去结束进程。

If the connection is lost and you reconnect with mysql_ping(), the thread ID changes. This means you should not get the thread ID and store it for later. You should get it when you need it.

如果失联，使用mysql_ping()来重新连接，线程id会改变。意味着，你不应该获取线程ID并将其存储以备以后使用。你应该在需要的时候得到它。

Note：

This function does not work correctly if thread IDs become larger than 32 bits, which can occur on some systems. To avoid problems with mysql_thread_id(), do not use it. To get the connection ID, execute a SELECT CONNECTION_ID() query and retrieve the result.

在一些系统上，如果线程id大小超过32位该函数不起作用。为了避免这样情况发生，不用使用mysql_thread_id()，为了获取id，执行select connect_id()查询并获取结果。

Return Values

The thread ID of the current connection.

返回的值

当前连接线程的id