Oppure
#include <stdio.h> #include <mysql.h> MYSQL *conn; MYSQL_RES *result; MYSQL_ROW row; char query[250]; const char* host = "localhost"; // host const char* database = "mydb"; // database const char* db_user = "root"; // nome utente const char* db_pass = "passwd"; // password int main (int argc, char *argv[]) { conn = mysql_init (NULL); mysql_real_connect (conn, /* connection handler */ host, /* host */ db_user, /* user name */ db_pass, /* password */ database, /* database */ 0, /* porta */ NULL, /* socket */ 0); /* flags */ strcpy(query, "SELECT titolo from test.persona;"); mysql_query(conn, query); result = mysql_use_result(conn); while ((row = mysql_fetch_row(result))) { printf("Id: %s Cognome: %s Nome: %s Eta: %s \n", row[0], row[1], row[2], row[3]); } mysql_close (conn); exit (0); }