vc调用mysql数据库

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

int main() {
    MYSQL* conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, "localhost", "user", "password", "database", 3306, NULL, 0)) {
        std::cerr << "Connection error: " << mysql_error(conn) << std::endl;
        return 1;
    }
    std::cout << "Connected successfully!" << std::endl;
    mysql_close(conn);
    return 0;
}

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

int main() {
    MYSQL* conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, "localhost", "user", "password", "database", 3306, NULL, 0)) {
        std::cerr << "Connection error: " << mysql_error(conn) << std::endl;
        return 1;
    }

    const char* sql = "SELECT * FROM table_name";
    if (mysql_query(conn, sql)) {
        std::cerr << "Query error: " << mysql_error(conn) << std::endl;
        mysql_close(conn);
        return 1;
    }

    MYSQL_RES* result = mysql_store_result(conn);
    if (result) {
        MYSQL_ROW row;
        while ((row = mysql_fetch_row(result))) {
            // Process the row data
        }
        mysql_free_result(result);
    }

    mysql_close(conn);
    return 0;
}