title: mysql query Insert does not work
body: <p>I am trying to insert a field into a mysql db but it does not work.</p>
  
  <p>I have tried to change around abit using just "insert into image", using an query string insteed of the string literal. 
  I looked <a href="http://www.yolinux.com/TUTORIALS/MySQL-Programming-C-API.html" rel="nofollow noreferrer">here</a> to try understand if syntax was different or something. </p>
  
  <p>I think Iam doing it according to the <a href="http://dev.mysql.com/doc/refman/5.7/en/mysql-query.html" rel="nofollow noreferrer">API</a>.</p>
  
  <p><a href="https://imgur.com/q4lC2O9" rel="nofollow noreferrer">Here</a> my setup</p>
  
  <p>From the out put i get </p>
  
  <pre><code>i = 1
  MySQL Tables in mysql database:
  images
  </code></pre>
  
  <p>here is the code.</p>
  
  <p>Any ideas? </p>
  
  <pre><code>    /* Simple C program that connects to MySQL Database server*/
  #include &lt;mysql.h&gt;
  #include &lt;stdio.h&gt;
  #include &lt;stdlib.h&gt;
     int main() {
        MYSQL *conn;
        MYSQL_RES *res;
        MYSQL_ROW row;
        char *server = "localhost";
        char *user = "root";
        //set the password for mysql server here
        char *password = "********"; 
        char *database = "myDB";
        conn = mysql_init(NULL);
        if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0))
        {
            fprintf(stderr, "%s\n", mysql_error(conn));
            exit(1);
        }
        /* send SQL query */
        if (mysql_query(conn, "show tables") == 1)
        {
            fprintf(stderr, "%s\n", mysql_error(conn));
            exit(1);
        }
      int i = mysql_query(conn ,"INSERT INTO `myDB`.`images` (`id`, `date`, `path`) VALUES (NULL, CURRENT_TIMESTAMP, 'mypath/foo/bar')");
      printf("i = %d \n", i);
        res = mysql_use_result(conn);
        /* output table name */
        printf("MySQL Tables in mysql database:\n");
        while ((row = mysql_fetch_row(res)) != NULL)
        {
            printf("%s \n", row[0]);
        }
        /* close connection */
        mysql_free_result(res);
        mysql_close(conn);
      return 0;
      }
  </code></pre>