Why do I fail making a database and tables?

#define $\_$CRT$\_$SECURE$\_$NO$\_$WARNINGS

#include

#include

#include $"$mysql$.$h$"$

#pragma comment$($lib$,$ "libmysql.lib"$)$

const char$*$ host $=$ "localhost"; $//$ change if necessary

const char$*$ user $=$ "root"; $//$ change if necessary

const char$*$ pw $=$ "dltjgus$43"$; $//$ change if necessary

const char$*$ db $=$ "project$2"$;

#define MAX$\_$LEN $13000$

void queryType$1($MYSQL$*$ conn$)$;

void queryType$2($MYSQL$*$ conn$)$;

void queryType$3($MYSQL$*$ conn$)$;

void queryType$4($MYSQL$*$ conn$)$;

void queryType$5($MYSQL$*$ conn$)$;

void queryType$6($MYSQL$*$ conn$)$;

void queryType$7($MYSQL$*$ conn$)$;

void queryResult$($MYSQL$*$ conn, const char$*$ query$)\{$

if $($mysql$\_$query$($conn$,$ query$))\{$

printf$("$Query failed: $\%$s

$",$ mysql$\_$error$($conn$))$;

return;

$\}$

MYSQL$\_$RES$*$ result $=$ mysql$\_$store$\_$result$($conn$)$;

if $($result $==$ NULL$)\{$

printf$("$Failed to retrieve result set: $\%$s

$",$ mysql$\_$error$($conn$))$;

return;

$\}$

int num$\_$fields $=$ mysql$\_$num$\_$fields$($result$)$;

MYSQL$\_$ROW row;

while $(($row $=$ mysql$\_$fetch$\_$row$($result$)))\{$

for $($int i $=0$; i $<$ num$\_$fields; $++$i$)\{$

if $($row$[$i$]!=$ NULL$)\{$

printf$("\%$s $",$ row$[$i$])$;

$\}$

else $\{$

printf$("$NULL $")$;

$\}$

$\}$

printf$("$

$")$;

$\}$

mysql$\_$free$\_$result$($result$)$;

$\}$

int main$($void$)\{$

MYSQL$*$ connection $=$ NULL;

MYSQL conn;

MYSQL$\_$RES$*$ sql$\_$result;

MYSQL$\_$ROW sql$\_$row;

FILE$*$ fp $=$ fopen$("$CRUD$.$txt$","$rt$")$;; $//$ open CRUD file.

char line$[$MAX$\_$LEN$]$;

int state $=0$;

int enter;

if $($fp $==$ NULL$)\{$

fprintf$($stderr$,$ "open file error!"$)$;

exit$(0)$;

$\}$

if $($mysql$\_$init$($&conn$)==$ NULL$)\{$

printf$("$mysql$\_$init$()$ error!"$)$;

return $1$;

$\}$

connection $=$ mysql$\_$real$\_$connect$($&conn, host, user, pw$,$ db$,3306,($const char$*)$NULL$,0)$;

if $($connection $==$ NULL$)\{$

printf$("\%$d ERROR : $\%$s

$",$ mysql$\_$errno$($&conn$),$ mysql$\_$error$($&conn$))$;

return $1$;

$\}$

else $\{$

printf$("$Connection Succeeded

$")$;

while $($fgets$($line$,$ sizeof$($line$),$ fp$)!=$ NULL$)\{$

if $(!$strcmp$($line$,"$$$$

$"))//$ read lines from CRUD file, $\text{'}$$$$$\text{'}$ separates CREATE $/$ DELETE parts.

break;

mysql$\_$query$($connection$,$ line$)$;

$\}$

if $($mysql$\_$select$\_$db$($&conn, "project$2"))\{$

printf$("\%$d ERROR : $\%$s

$",$ mysql$\_$errno$($&conn$),$ mysql$\_$error$($&conn$))$;

return $1$;

$\}$

const char$*$ query $=$ "SELECT $*$ FROM customer";

state $=$ mysql$\_$query$($connection$,$ query$)$;

if $($state $==0)\{$

sql$\_$result $=$ mysql$\_$store$\_$result$($connection$)$;

printf$("[$ SELECT $*$ FROM CUSTOMER $]$

$")$;

while $(($sql$\_$row $=$ mysql$\_$fetch$\_$row$($sql$\_$result$))!=$ NULL$)$

printf$("\%$s $\%$s $\%$s $\%$s

$",$ sql$\_$row$[0],$ sql$\_$row$[1],$ sql$\_$row$[2],$ sql$\_$row$[3])$;

mysql$\_$free$\_$result$($sql$\_$result$)$;

$\}$

$//$ comment out if you want to persist example db instance.

while $($fgets$($line$,$ sizeof$($line$),$ fp$)!=$ NULL$)\{$

mysql$\_$query$($connection$,$ line$)$; $//$ these are DELETEs & DROPs.

$\}$

fclose$($fp$)$;

return $0$;

$\}$