C++ mysqlclient

1.Install mysqlclient

sudo apt-get install mysql-client

C++ mysqlclient

2.Add #include <mysql/myql.h> and cpp file

#include <iostream>
#include <mysql/mysql.h>

using namespace std;

void mysqlClientDemo();

int main(int args, char **argv)
{
    mysqlClientDemo();
}

void mysqlClientDemo()
{
    MYSQL_RES *result;
    MYSQL_ROW row;
    MYSQL *conn, mysql;
    int state;

    mysql_init(&mysql);
    conn = mysql_real_connect(&mysql, "localhost", "root", "Password", "myDB", 0, 0, 0);

    if (conn == NULL)
    { 
        cout<<mysql_error(&mysql)<<endl; 
        return;
    }

    state = mysql_query(conn, "select * from mt limit 100;");
    if (state != 0)
    {
        cout<<mysql_error(conn)<<endl;
        return;
    }

    result = mysql_store_result(conn);
    cout<< mysql_num_rows(result)<<endl;
    while ((row = mysql_fetch_row(result)) != NULL)
    {
        cout<<"Index="<<row[0]<<",Id="<<row[1]<<",Name="<<row[2]<<",Title="<<row[3]<<endl;
    }
}

3.Compile

 g++ -g -std=c++2a -I. -Wall -I/usr/include/mysql/ *.cpp -o h1 -L/usr/lib -lmysqlclient;

4. Execute

./h1 0

C++ mysqlclient

When I remove the limit 100 strictions and select *from table it will return all which illustrated its performance is awesome.

C++ mysqlclient

原文链接: https://www.cnblogs.com/Fred1987/p/16274990.html

欢迎关注

微信关注下方公众号，第一时间获取干货硬货；公众号内回复【pdf】免费获取数百本计算机经典书籍;

也有高质量的技术群，里面有嵌入式、搜广推等BAT大佬

原创文章受到原创版权保护。转载请注明出处：https://www.ccppcoding.com/archives/401464

非原创文章文中已经注明原地址，如有侵权，联系删除

关注公众号【高性能架构探索】，第一时间获取最新文章

转载文章受原作者版权保护。转载请注明原作者出处！

C++ mysqlclient

相关推荐