There seems to be a mysql error with a syntax issue causing an ER_PARSE_ERROR with errno 106

Question

There seems to be a mysql error with a syntax issue causing an ER_PARSE_ERROR with errno 106

Encountered a Syntax error:

You have an error in your SQL syntax, please refer to the manual corresponding to your 
MySQL server version for the correct syntax to use near :data at line 1.
errno: 1064
SqlState: '42000'

This is The code used for database insertion:

function addCategory(category){
    var execution = q.defer();
    var query = 'INSERT INTO categories SET :data';
    console.log(query);
    connection.query(query,{data:category}, function(err, res){
        if(err){
            execution.reject(err);
            console.log(err);
            return;
        }
        execution.resolve(res);
    });
    return execution.promise;
}

This function expects a category as a JSON object. Interestingly, this function worked previously and was implemented similarly to the one causing the error.

Any insights on how to resolve this issue?

javascript mysql express

Answer 1

Answer №1

It appears that the query you are attempting to execute is invalid. Please refer to the INSERT syntax documentation for guidance. Typically, an INSERT query will resemble the format shown below:

INSERT INTO table_name (column1, column2) VALUES(value1, value2);

In your specific case, it is recommended to modify your query as follows:

var query = 'INSERT INTO categories (category) VALUES(:data)';

(Replace category with the name of your actual column)

Answer 2

It appears that the query you are attempting to execute is invalid. Please refer to the INSERT syntax documentation for guidance. Typically, an INSERT query will resemble the format shown below:

INSERT INTO table_name (column1, column2) VALUES(value1, value2);

In your specific case, it is recommended to modify your query as follows:

var query = 'INSERT INTO categories (category) VALUES(:data)';

(Replace category with the name of your actual column)

Answer 3

Answer №2

#handling SQL queries in Express

#using PUT request for updating data
#data= req.body

 
pool.query("INSERT INTO product set ?", data, (error, results, fields) => {
            if (error) {return callBack(error);}
            return callBack(null, results);
        });


#sample data to be inserted
{
  "id": "4",
  "name": "tested1",
  "description": "cool",
  "final_rating": "3",
  "price": "4",
  "image_loc": "c"
}

#############################################

#using DELETE request

#data to delete
{
  "id":"1"
}

pool.query("delete from product where id=?", data, (error, results, fields) => {
        if (error) {return callBack(error);}
        return callBack(null, results);
    });

#data = req.body.id

Answer 4

#handling SQL queries in Express

#using PUT request for updating data
#data= req.body

 
pool.query("INSERT INTO product set ?", data, (error, results, fields) => {
            if (error) {return callBack(error);}
            return callBack(null, results);
        });


#sample data to be inserted
{
  "id": "4",
  "name": "tested1",
  "description": "cool",
  "final_rating": "3",
  "price": "4",
  "image_loc": "c"
}

#############################################

#using DELETE request

#data to delete
{
  "id":"1"
}

pool.query("delete from product where id=?", data, (error, results, fields) => {
        if (error) {return callBack(error);}
        return callBack(null, results);
    });

#data = req.body.id

There seems to be a mysql error with a syntax issue causing an ER_PARSE_ERROR with errno 106

Answer №1

Answer №2

Similar questions

Submit button in React form not activating the onSubmit method

Creating a controller API in Express and Mongoose to send multiple "FIND" requests in a single query - a step-by-step guide

Specific Character Count in Regular Expressions

Struggling with parsing JSON strings into PHP arrays

Is there a way to decrease the jQuery UI file size?

Implementing AngularJS table filters on user click

What are some ways I can utilize Babel in standalone mode to convert an HTML import into a variable declaration?

Tips for properly invoking a function from one component to another component

Working with SQLite Database on Android with Inserted Data Row

Is this the correct method for implementing AJAX syntax?

Tips for assigning identifiers to dynamically generated elements in KnockOutJS

Creating a dynamic side navigation menu that adjusts to different screen sizes

Obtain the location information upon the loading of the webpage

How can I ensure that remote_form_for adds new code in addition to existing code rather than replacing it in RoR?

Changing the disabled textfield colour in Material-UI

Different outcome when passing parameter in MySql

Invoke a separate function from the ajax() success callback

Update the state of a button in an HTML header file

Switching jQuery toggle effects to Angular framework

Apollo GraphQL has initiated the detection of a new subscription