Error when using mysql in c

Question

I'm coding a setup for my "game" server and I use MySQL for database. I getting an error when I create the database + table and the columns. I tested the Mysql code in phpmyadmin and it worked.

Here's a sample of my code: `

int area;
char user[100];
char pass[100];
char ip[200];
char tentativaspm;
void mysqlsetup(){


  MYSQL *CON = mysql_init(NULL);
  if (CON == NULL)
  {
    fprintf(stderr, "%s\n", mysql_error(CON));
    exit(1);

  }
  if (mysql_real_connect(CON, ip, user, pass,
          NULL, 0, NULL, 0) == NULL)
  {
      fprintf(stderr, "%s\n", mysql_error(CON));
      mysql_close(CON);
      sleep(2);
      userepassmysql();
  }
  printf("Conecao establecida.\n");
  if(mysql_query(CON, "CREATE DATABASE place;")){
      fprintf(stderr, "%s\n", mysql_error(CON));
      mysql_close(CON);
      exit(1);


  }


if(mysql_query(CON, "USE place; CREATE TABLE grid (pixelID int,color int);"){
      fprintf(stderr, "%s\n", mysql_error(CON));
      mysql_close(CON);
      exit(1);

}

And I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE grid CREATE TABLE grid (pixelID int(11) NOT NULL,color int(11) NOT N' at line 1

marc_s · Accepted Answer · 2017-10-08 14:27:24Z

2

By default the mysql_query c function doesn't support multiple SQL statements. But you can combine the two queries

USE [database];
CREATE TABLE grid (pixelID int,color int)

into the oneliner

CREATE TABLE [database].grid (pixelID INT, color INT)

Note replace [database] with the correct database name.

Solution one

Using the oneliner

if(mysql_query(CON, "CREATE TABLE place.grid (pixelID int,color int);"){

Solution two

Use the function mysql_set_server_option() function to enable multiple SQL statements.

mysql_set_server_option(connection, MYSQL_OPTION_MULTI_STATEMENTS_ON);

edited Oct 8, 2017 at 14:27

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 8, 2017 at 11:59

Raymond Nijland

11.6k2 gold badges26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luís Duarte Over a year ago

Thank you :D Have a nice day.

Collectives™ on Stack Overflow

Error when using mysql in c

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related