Search code examples
mysqlmysql-error-1064

1064; You have an error in your SQL syntax;

I have this 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 'n')' at line 1 INSERT INTO oc_url_alias (query, keyword) VALUES ('product_id=26834', 'Stick'n');

My query:

INSERT INTO oc_url_alias (query, keyword) VALUES ('product_id=26834', 'Stick'n')

i don't know what to do

Solution 
  • INSERT INTO oc_url_alias (query, keyword) VALUES ('product_id=26834', 'Stick\'n');