mySql delete

include

include

int main() { MYSQL* conn; conn = mysql_init(0);

conn = mysql_real_connect(conn, "localhost", "username", "password", "database_name", 0, NULL, 0);

if(conn){
    std::cout << "Connected to database" << std::endl;
    if(mysql_query(conn, "DELETE FROM table_name WHERE condition")){
        std::cout << "Delete operation failed: " << mysql_error(conn) << std::endl;
    } else {
        std::cout << "Delete operation successful" << std::endl;
    }
} else {
    std::cout << "Connection failed" << std::endl;
}

mysql_close(conn);

return 0;

}