CODEWITHSUNDEEP
mysqldatabasemagento
fresher
fresher

Reputation: 911

magento #1064 - You have an error in your SQL syntax;

we are using magento platform with MYSQL

i am runing folowing query in database :

INSERT INTO eav_attribute (age, ...) VALUES (1020, ....);

here age is attribute code and 1020 is attribute id.

but i am getting following error :

1064 - 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 '..) VALUES (1020, ....)' at line 1

Upvotes: 0

Views: 342

Answers (1)

Rahul
Rahul

Reputation: 77876

If you are inserting only one field then change it to

INSERT INTO eav_attribute(age) VALUES(1020);

If your column of type VARCHAR you need to quote your column values using single quote '. It should be

VALUES ('1020'

Upvotes: 1

Related Questions