C++ mysql_client insert into table

1.Source code in h1.cpp

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

using namespace std;

void mysqlClientInsert2();

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

void mysqlClientInsert2()
{
    try
    { 
        MYSQL *conn, mysql;
        int state;

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

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

        string str = "Insert into mt(BookId,BookName,BookTitle) values(1,'C++','C++ Programming Books!')";
        state=mysql_query(conn, str.c_str());
        cout<<"State ="<<state<<endl;
    }
    catch (const std::exception &e)
    {
        std::cerr << e.what() << 'n';
    }
}

2.Compile via c++ as below command

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

3.Execute

./h1 -1;

4.Result

C++ mysql_client insert into table

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

欢迎关注

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

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

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

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

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

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

C++ mysql_client insert into table

相关推荐