111.cpp: Defines the entry point for the console application.
//
#include "stdafx.h"
#include <windows.h>
#include <iostream>
#include <D:\TDdownload\MySQL\111\include\mysql\mysql.h>
int main (int argc,char* argv[])
{
Char *user = "root", *pwd = "123456", *dbname = "Chardb";
MySQL MySQL;
Mysql_res *mysql_ret;
Mysql_row Mysql_row;
unsigned long num_rows;
int ret;
Mysql_init (&mysql);
if (Mysql_real_connect (&mysql,null,user,pwd,dbname,0,null,0))
{
printf ("Connected successfully!\n");
ret = mysql_query (&mysql, "SELECT * from Accounts");
if (!ret)
{
printf ("Query success!\n");
Mysql_ret = Mysql_store_result (&mysql);
if (Mysql_ret!= NULL)
{
printf ("Storage results successful!\n");
Num_rows = mysql_num_rows (Mysql_ret);
if (num_rows!= 0)
{
printf ("%d\n", num_rows);
while (Mysql_row = Mysql_fetch_row (Mysql_ret))
{
printf ("%s\t%s\t%s\t%s\t%s\t%s\n", mysql_row[0],mysql_row[1],mysql_row[2],mysql_row[3],mysql_row[4],mysql_row[5 ]);
}
}
Else
{
Exit (-1);
}
Mysql_free_result (Mysql_ret);
Exit (0);
}
Else
{
Exit (-1);
}
}
Else
{
Exit (-1);
}
}
Else
{
printf ("Connection failed \ n");
Exit (-1);
}
}