CODEWITHSUNDEEP
mysqlphpmyadmin
Bram
Bram

Reputation: 645

Query works locally not online

I have this simple query that works when I try it locally but not online, probably some version difference?

UPDATE wp_posts SET post_content = 'blah blah' WHERE post_type = 'product'

This query is working locally but online I get 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 '\'blah blah' at line 1

Server info phpmyadmin, php version seems to be 5.5 it refers to this manual

http://dev.mysql.com/doc/refman/5.5/en/index.html

Upvotes: 0

Views: 226

Answers (1)

000
000

Reputation: 3950

try this

UPDATE `databaseName`.`wp_posts` SET `post_content` = 'blah blah' WHERE `wp_posts`.`post_type` = 'product';

Upvotes: 1

Related Questions