#include <my_global.h>
#include <m_string.h>
#include <mysql.h>

#define DB_HOST			"localhost"
#define DB_USER			"root"
#define DB_PASSW		""
#define DB_NAME			"test"
#define DB_PORT			3306
#define DB_UNIX_SOCKET	NULL

void main( void )
{
  MYSQL mysql;
  int x;
	char my_sub[255],my_query[255];
 
  mysql_init(&mysql);
  
   
  if (!mysql_real_connect(&mysql,DB_HOST,DB_USER,DB_PASSW,DB_NAME,
						   DB_PORT,DB_UNIX_SOCKET,0))
  {
    printf("Error: %s\n",mysql_error(&mysql));
    return;
  }
  else
	 printf("Connected to the server: %s\n",mysql_get_server_info(&mysql));

  for (x = 1; x <= 500000; x++)
  {
	  int10_to_str((int) x,strmov(my_sub,"Create Table if not exists tb"), 10);

	  strxnmov(my_query,sizeof(my_query)-1,my_sub,
		" (id int not null auto_increment primary key, name varchar(200))engine=Falcon",NullS);
	
    if (mysql_query( &mysql, my_query) )
	  {
        printf("Error (query): %s\n", mysql_error( &mysql ));
        printf("Number of tables created: %d\n",x);
        mysql_close( &mysql );
        return;
	  }
  }
  printf("Number of tables created: %d\n",x);
  mysql_close(&mysql);
}