Debian下使用C++连接MySQL。

首先，安装libmysql++。

然后，基本用法如下：

#include <mysql++.h>

#include <iostream>

using namespace std;

int main(int argc, char *argv[])
{
    mysqlpp::Connection conn;

    conn.set_option(new mysqlpp::SetCharsetNameOption("utf8"));

    if (conn.connect("db_name", "db_server", "db_user_name", "db_user_pass"))
    {
        mysqlpp::Query            query_01 = conn.query("select * from issuer_sector_table order by issuer_sector_id");
        mysqlpp::StoreQueryResult res_01 = query_01.store();

        if (res_01)
        {
            for (size_t i = 0; i < res_01.num_rows(); i++)
            {
                cout << res_01[i]["issuer_sector_id"] << "\t" << res_01[i]["issuer_sector"]<< endl;
            }
        }
        else {
            cerr << "Failed to get stock table: " << query_01.error() << endl;
            return 1;
        }

        mysqlpp::Query        query_02 = conn.query("insert into issuer_sector_table (issuer_sector) values ('---')");
        mysqlpp::SimpleResult res_02 = query_02.execute();

        cout << res_02.insert_id() << endl;

        return 0;
    }
    else {
        cerr << "DB connection failed: " << conn.error() << endl;
        return 1;
    }
}

注意：要设定编码。