====== mysql_create_db ======
int mysql_create_db(MYSQL *mysql, const char *db)
==== description of mysql_create_db ====
creates the database named by the db parameter. \\
mysql_create_db deprecated use mysql_query() to create a database
#include /* including standard library */
#include
MYSQL *my;
MYSQL_ROW row;
MYSQL_RES *mysql_res;
int main( void ){
char host[20];
char user[20];
char pass[20];
unsigned long numrows = 0;
my = mysql_init(NULL);
sprintf(host,"localhost");
sprintf(user,"username");
sprintf(pass,"password");
if (my == NULL ) {
printf("Cant initalisize MySQL\n");
return 1;
}
if( mysql_real_connect (my,host,user,pass,NULL,0,NULL,0) == NULL) {
printf("Error cant login\n");
} else {
printf("Login correct\n");
}
mysql_create_db(my,"test");
printf("test db created\n");
mysql_close(my);
return 0;
}
===== output of mysql_create_db c example =====
Login correct
test db created