c 操作mysql创建新表_C程序中怎么用mysql C API 创建新表table

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

MYSQL imysql ;

MYSQL_RES * mydata;

unsigned int num_fields;

unsigned int num_rows;

unsigned long *lengths;

MYSQL_ROW row,;

MYSQL_FIELD *fields;

char a[241]="";

char querystring[241]="";

void mysqlinit(char user[20], char password[20], char db[20]);

void main()

{

mysqlinit("username","userpassword","database");

a[0] ='\0';

strcat(a,"Create Table ");

strcat(a,tablename);

strcat(a,"(pepsi bigint Not Null Primary,coke bigint Not Null);");

printf(a);

strcpy(querystring,a);

if (!mysql_real_query(&imysql,querystring,strlen(querystring)))

{ mydata = mysql_store_result(&imysql); }

else

{ printf("Oops ! Error %d:

%s\n",mysql_errno(&imysql),mysql_error(&imysql));

mysql_close(&imysql);

exit(0);

}

mysql_close(&imysql);

}

void mysqlinit(char user[20], char password[20], char db[20])

{

mysql_init(&imysql);

mysql_options(&imysql,MYSQL_READ_DEFAULT_GROUP,"your_prog_name");

if (!mysql_real_connect(&imysql,"",user,password,db,0,NULL,0))

{

fprintf(stderr,"FAILED !!!! Error %s\n",mysql_error(&imysql));

}

else

{

printf( "Connection with Database established !\n");

}

}