c++连接mysql的编译命令,连接mysql的c++代码段

#include

#include

using namespace std;

int main()

{

if(mysql_library_init(0,NULL,NULL)){

cout<

exit(-1);// 初始化数据库

}

MYSQL mysql;

mysql_init(&mysql); //初始化一个连接句柄

unsigned int timeout = 3000;

mysql_options(&mysql, MYSQL_OPT_CONNECT_TIMEOUT, &timeout); //设置超时

if (!mysql_real_connect(&mysql, "localhost", "root", "@Luwc1009", "test", 0, NULL, 0))

{

std::cout << "Error: connect mysql failed: " << mysql_error(&mysql) << std::endl;

mysql_close(&mysql);

return -1;

}

char* stmt = const_cast("select * from people");

int length = strlen(stmt);

if (mysql_real_query(&mysql, stmt, length))

{

printf("mysql_real_query error\n");

return 0;

}

MYSQL_RES *result;

MYSQL_ROW row;

unsigned int num_fields;

unsigned int num_rows;

result = mysql_store_result(&mysql);

if (result)

{

num_fields = mysql_num_fields(result); //这里获取结果集中的列数

printf("num_fields = %d\n", num_fields);

while((row = mysql_fetch_row(result))) //遍历结果集中每一行

{

unsigned long *lengths;

lengths = mysql_fetch_lengths(result); //获取每个字段的实际长度

for (unsigned int i = 0; i < num_fields; ++i) //输出每个字段

{

printf("%s ", row[i] ? row[i] : NULL);

}

}

printf("\n");

}

mysql_free_result(result); //释放内存

mysql_close(&mysql);

mysql_library_end();

}

编译命令是：g++ -g main2.cpp -o test mysql_config --cflags --libs

标签：int,fields,代码段,c++,num,result,mysql,row

来源： https://blog.csdn.net/weixin_38258767/article/details/114396591