mysql test program

mysql_test.cpp (text/x-c++src), 654 bytes, created by Wallance on 2015-10-05 04:00:16 UTC

#include <mysql/mysql.h>
#include <stdio.h>

int main()
{
    MYSQL *mysql_conn;
    MYSQL_RES *mysql_res;
    MYSQL_ROW mysql_row;

    mysql_init(mysql_conn);
    if (!mysql_conn)
        printf("mysql_init error!\n");
    mysql_conn = mysql_real_connect(mysql_conn, NULL, "root", "h8kh3eg", "mysql", 0, NULL, 0);
    if (!mysql_conn)
        printf("mysql_real_connect error!\n");
    mysql_query(mysql_conn, "SELECT * FORM db");
    mysql_res = mysql_use_result(mysql_conn);
    while (mysql_row = mysql_fetch_row(mysql_res)) {
         printf("%s\n", *mysql_row);
    }
    mysql_free_result(mysql_res);
    mysql_close(mysql_conn);
    return 0;
}