mysql

#include <iostream>
#include <mysql_driver.h>
#include <mysql_connection.h>

int main() {
    sql::mysql::MySQL_Driver *driver;
    sql::Connection *con;

    driver = sql::mysql::get_mysql_driver_instance();
    con = driver->connect("tcp://127.0.0.1:3306", "username", "password");

    con->setSchema("database_name");

    sql::Statement *stmt;
    sql::ResultSet *res;

    stmt = con->createStatement();
    res = stmt->executeQuery("SELECT * FROM table_name");

    while (res->next()) {
        std::cout << "Column 1: " << res->getString("column1") << std::endl;
        std::cout << "Column 2: " << res->getInt("column2") << std::endl;
        // Add more columns as needed
    }

    delete res;
    delete stmt;
    delete con;

    return 0;
}