A simple mysql sample

#include <winsock2.h>
#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <mysql.h>
#pragma comment(lib,"libmysql")
int _tmain(int argc, _TCHAR* argv[])
{
MYSQL* mysql;
MYSQL_RES* results;
MYSQL_ROW record;
mysql = mysql_init(NULL);
if(!mysql)
{
printf("mysql_init error!\n");
}
if(!mysql_real_connect(mysql, NULL,"root","sbivfh", "mysql", 3306,NULL,0))
{
printf("Failed to connect to database: Error: %s\n",mysql_error(mysql));
}
if(mysql_query(mysql,"select User from user"))
{
printf("mysql_query: Error: %s\n",mysql_error(mysql));
}
results = mysql_store_result(mysql);
my_ulonglong ulNum = mysql_num_rows(results);
while(record = mysql_fetch_row(results))
{
printf("%s",record[0]);
}
mysql_free_result(results);
mysql_close(mysql);
mysql_server_end();
return 0;
}
//use proc
--2009-09-21
#include <winsock2.h>
#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <mysql.h>
#pragma comment(lib,"libmysql")
int _tmain(int argc, _TCHAR* argv[])
{
MYSQL* mysql;
MYSQL_RES* results;
MYSQL_ROW record;
char szProcQueryUser[256];
ZeroMemory(szProcQueryUser,256);
/*
create table user1 (userid int not null);
delimiter //
create procedure queryuser1 ()
begin
insert into user1 (userid) values (5);
end
//
*/
mysql = mysql_init(NULL);
if(!mysql)
{
printf("mysql_init error!\n");
}
if(!mysql_real_connect(mysql, NULL,"root","sbivfh", "mysql", 3306,NULL,0))
{
printf("Failed to connect to database: Error: %s\n",mysql_error(mysql));
}
strcpy(szProcQueryUser,"call queryuser1()");
if(mysql_real_query(mysql,szProcQueryUser,(unsigned int)strlen(szProcQueryUser)))
{
printf("mysql_real_query: Error: %s\n",mysql_error(mysql));
}
if(mysql_query(mysql,"select userid from user1"))
{
printf("mysql_query: Error: %s\n",mysql_error(mysql));
}
results = mysql_store_resu