User Tools

Site Tools


Sidebar

Programming Reference/Librarys

Question & Answer

Q&A is closed







c:mysql:mysql.h:mysql_create_db

mysql_create_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 <stdio.h> /* including standard library */ 
#include <mysql/mysql.h>
 
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

on the occasion of the current invasion of Russia in Ukraine

Russian Stop this War
c/mysql/mysql.h/mysql_create_db.txt · Last modified: 2024/02/16 01:12 (external edit)

Impressum Datenschutz