ubuntu 使用mysql编译

安装指令

sudo apt install  libmysql++-dev

示例代码

#include <iostream>
#include <mysql/mysql.h>
using namespace std;
int main()
{
    
    MYSQL *conn = mysql_init(NULL);
    conn = mysql_real_connect(conn, "112.124.96.52", "root", "20110812", "hqmj_manage", 3306, NULL, 0);
    if(!conn){
        cout<<"mysql_real_connect"<<endl;
        exit(1);
    }
    
    mysql_query(conn, "set names utf8");
    
    int res = mysql_query(conn, "select * from hqmj_employee");
    if(res){
        cout<<"mysql_query:"<<mysql_error(conn)<<endl;
        exit(1);
    } else {
        MYSQL_RES *result = mysql_store_result(conn);
        if(result){
            for(int i = 0; i < mysql_num_rows(result); i++){
                MYSQL_ROW row = mysql_fetch_row(result);
                for(int j = 0; j < mysql_num_fields(result); j++){
                    cout<<row[j]<<endl;
                }
            }
        }
        mysql_free_result(result);
    }

     res = mysql_query(conn, "insert into hqmj_employee values(60, 'b')");
     if(res){
         cout<<"mysql_query:"<<mysql_error(conn)<<endl;
         exit(1);
     }
    mysql_close(conn);
    return 0;
}