MySQL C++连接器:如何获取线程/连接Id？

#include <mysql_driver.h>
#include <mysql_connection.h>

// 创建MySQL连接
sql::mysql::MySQL_Driver *driver;
sql::Connection *con;
driver = sql::mysql::get_mysql_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "user", "password");

// 获取连接ID
unsigned long connectionId = con->getMetaData()->getThreadId();

// 获取线程ID
unsigned long threadId = mysql_thread_id(con->getMySQLConnection());

// 打印连接ID和线程ID
std::cout << "Connection ID: " << connectionId << std::endl;
std::cout << "Thread ID: " << threadId << std::endl;

// 关闭连接
delete con;

#include <mysql_driver.h>
#include <mysql_connection.h>

// 创建MySQL连接
sql::mysql::MySQL_Driver *driver;
sql::Connection *con;
driver = sql::mysql::get_mysql_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "user", "password");

// 执行查询语句获取连接ID
MYSQL_RES *result;
MYSQL_ROW row;
mysql_query(con->getMySQLConnection(), "SELECT CONNECTION_ID()");
result = mysql_store_result(con->getMySQLConnection());
row = mysql_fetch_row(result);
unsigned long connectionId = std::stoul(row[0]);

// 获取线程ID
unsigned long threadId = mysql_thread_id(con->getMySQLConnection());

// 打印连接ID和线程ID
std::cout << "Connection ID: " << connectionId << std::endl;
std::cout << "Thread ID: " << threadId << std::endl;

// 释放结果集
mysql_free_result(result);

// 关闭连接
delete con;