mysql_stmt_result_metadata使用_MySQL C API - 在调用mysql_store_result()或mysql_stmt_store_result()之后重用连接...

对于“Select”sql，在我们通过调用my_fetch_xxx()API复制所有行之前，重复使用连接来调用my_xxxx_store()API(以缓存客户端中的所有结果)通过调用my_xxxx_store()API缓存？

例如，通过传递不同的select语句，该函数是否可以正确地获取数据，而不会有任何问题(如果它是从多个线程调用的)。

就像同时打电话

From thread-1: foo("select * from table1");

From thread-2: foo("select * from table2");

From thread-3: foo("select * from table3");

etc....函数foo是类似的。

/* Assume that "connection" is a valid properly initialiaed mysql connection handle global variabale*/

/* Assume that there is only one result set. (Means that we dont need to call mysql_next_result() ) */

foo( char *sqlStatement )

{

threadLock();

mysql_real_query( connection, sqlStatement, ... );

MYSQL_RES* result = mysql_store_result(connection);

threadUnLock();

/* The "connection" can be reused now, since all data is cached in client. */

while( more data rows )

{

MYSQL_ROW row = mysql_fetch_row(result);

/*

Copy data;

*/

}

mysql_free_result(result);

}准备好的报表也安全吗？就像是。

bar( char *sqlStatement, char *params[] )

{

threadLock();

MYSQL_STMT *stmt = mysql_stmt_init(connection);

mysql_stmt_prepare(stmt, sqlStatement, ...);

int paramCount= mysql_stmt_param_count(stmt);

MYSQL_RES *metaResult = mysql_stmt_result_metadata(stmt);

int columnCount= mysql_num_fields(metaResult)

mysql_stmt_execute(stmt);

mysql_stmt_bind_result(stmt, ....)

mysql_stmt_store_result(stmt);

threadUnLock();

/* The "connection" can be reused now, since all data is cached in client. */

while( more data rows )

{

MYSQL_ROW row = mysql_stmt_fetch(stmt);

/*

Copy data;

*/

}

mysql_free_result(metaResult);

mysql_stmt_free_result(stmt);

mysql_stmt_close(stmt);

}