//gcc prepare.c -g -o prepare -L/home/sbester/server/5.0/mysql-5.0-bk/mysql-5.0.30-linux-i686/lib -I/home/sbester/server/5.0/mysql-5.0-bk/mysql-5.0.30-linux-i686/include   -lmysqlclient_r -lz

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



int main(int argc, const char *argv[])
{
	MYSQL *dbc=NULL;
	MYSQL_STMT *stmt=NULL;
	char *query="select dfgdfg";
	
	if (!(dbc = mysql_init(NULL)))
	{
		printf("mysql_init failed\n");
		return 1;
	}
	printf("mysql_init done\n");
	
	
	if (!mysql_real_connect(dbc,"127.0.0.1","root","","test",3306, NULL, CLIENT_FOUND_ROWS|CLIENT_MULTI_STATEMENTS|CLIENT_MULTI_RESULTS))
	{
		printf("mysql_real_connect failed: %s (%d)\n", mysql_error(dbc),mysql_errno(dbc));
		return 1;
	}
	printf("mysql_real_connect done\n");
	
	
	stmt = mysql_stmt_init(dbc);
	if(!stmt)
	{
		printf("mysql_stmt_init failed: %s (%d)\n", mysql_error(dbc),mysql_errno(dbc));
		return 1;
	}
	printf("mysql_stmt_init done\n");
	
	
	if (mysql_stmt_prepare(stmt, query, strlen(query)))
	{
		printf("mysql_stmt_prepare failed: %s (%d)\n",mysql_stmt_error(stmt),mysql_stmt_errno(stmt));
		//return 1;
	}
	printf("mysql_stmt_prepare done\n");
	
	
	if (mysql_stmt_close(stmt))
	{
		printf("mysql_stmt_close failed: %s (%d)\n",mysql_error(dbc),mysql_errno(dbc));
		return 1;
	}
	printf("mysql_stmt_close done\n");
	
		
	mysql_close(dbc);
	printf("mysql_close done\n");
	
	return 0;	
}