sudo apt install -y libmysqlclient-dev 

g++ -o $@ $^ -I./include -L./lib  -lmysqlclient

dpkg -L libmysqlclient-dev

MYSQL *mysql_init(MYSQL *mysql);

    //1.初始化
if(my==nullptr)
{
     std::cerr<<"init error"<<std::endl;
     return 1;
}

MYSQL *mysql_real_connect(MYSQL *mysql, const char *host,
const char *user,
const char *passwd,
const char *db,
unsigned int port,
const char *unix_socket,
unsigned long clientflag);

//2.連接
if(mysql_real_connect(my,host.c_str(),user.c_str(),password.c_str(),db.c_str(),port,nullptr,0)==nullptr)
{
    std::cerr<<"connect error"<<std::endl;
    return 2;
}

mysql_set_character_set(myfd, "utf8");

int mysql_query(MYSQL *mysql, const char *q);

//3.命令
std::string sql="select * from users";
int n=mysql_query(my,sql.c_str());
if(n==0)
{
    std::cout<<"query "<<sql<<" success"<<std::endl;
}
else
{
    std::cerr<<"query "<<sql<<" error"<<std::endl;
    return 3;
}

MYSQL_RES *mysql_store_result(MYSQL *mysql);

MYSQL_RES* res = mysql_store_result(my);

my_ulonglong mysql_num_rows(MYSQL_RES *res);

unsigned int mysql_num_fields(MYSQL_RES *res);

MYSQL_FIELD *mysql_fetch_fields(MYSQL_RES *res);

//屬性
 MYSQL_FIELD *fields_array = mysql_fetch_fields(res);
 for(int i=0;i<fields;i++)
 {
     std::cout<<fields_array[i].name<<"\t";
 }
 std::cout<<std::endl;

//數(shù)據(jù)
for(int i=0;i<rows;i++)
{
    MYSQL_ROW row = mysql_fetch_row(res);
    for(int j=0;j<fields;j++)
    {
        std::cout<<row[j]<<"\t";
    }
    std::cout<<std::endl;
}

 // 釋放結(jié)果空間
mysql_free_result(res);
 // 關(guān)閉mysql連接
mysql_close(my);