Database and C

#include <stdio.h>

#include <string.h>

#include <stdlib.h>

#include <sys/types.h>

#include <sys/param.h>

#include <sys/stat.h>

#include </usr/include/unistd.h>

#include "/usr/include/mysql/mysql.h"

main()

{

MYSQL *conn;

MYSQL_RES *res = NULL;

MYSQL_ROW row;

char *server="localhost";

char *user = "root";

char *password ="admin";

char *database = "test";

char query[100]="Select * from emp";

conn = mysql_init(NULL);

if (!mysql_real_connect(conn, server,user, password, database, 0, NULL, 0))

{

printf("Problem in Connecting To Database.......%s\n",database);

if(conn)

mysql_close(conn);

printf("Connection closed");

}

else

{

printf("\nDatabase Connected. Now Looking For Emp Table\n");

if(!mysql_query(conn,query))

{

printf("\nTable Exist in Database\n");

if(conn)

mysql_close(conn);

}else {

printf("\nTable Doesn't Exist\n");

strcpy(query,"create table emp(name varchar(20))");

if(!mysql_query(conn,query))

{

printf("\nTable Created\n");

if(conn)

mysql_close(conn);

}else

{

printf("\nError in Executing Query\n");

if(conn)

mysql_close(conn);

}

}

}

}

/////////////////////////////////////////////////////////////////////////////////////////////