C++ mysql

//①初始化MYSQL my=mysql_init(NULL); char ip[]="127.0.0.1"; char user[]="root"; char pass[]="123"; char database[]="testx"; int port = 3306; //②建立连接 if(mysql_real_connect(my,ip,user,pass,database,port,NULL,0)) { cout<<"connect success"<<endl; } else { cout<<"connect failed"<<endl; return; } //③准备查询结果需要的结构 MYSQL_RES* result; //返回查询结果 MYSQL_ROW row; //表示一行数据 int num; //③执行sql语句 if((mysql_query(my,"select * from person")) == 0) { cout<<"query success"<<endl; } //将结果地址存到result result = mysql_store_result(my); //有多少列 num = mysql_num_fields(result); int num2 = mysql_field_count(my); //本次操作影响了/查询到了多少行数据 int m = mysql_affected_rows(my); //打印列/字段名 for(int i=0;i<num2;i++) { MYSQL_FIELD *xx; xx = mysql_fetch_field(result); //每执行一次，就指向下一个位置 cout<<xx->name<<" "; } cout<<endl; //打印所有行数据 while(row=mysql_fetch_row(result)) { for(int i=0;i<num;i++) { cout<<row[i]<<" "; } cout<<endl; } //④关闭连接，释放资源 mysql_free_result(result); mysql_close(my);

 

 

https://www.php.cn/mysql-tutorials-64033.html

 

C++ mysql

标签：tps   需要   user   字段名   col   一个   fetch   字段   打印