SQL syntax error INNER JOIN

Question

I'm trying to run this sql query and keeps getting this error:

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 'INNER JOIN wp_posts ON wp_postmeta.post_id = wp_posts.ID WHERE wp_posts.post_typ' at line 3 (Line 4)

My sql query is this:

UPDATE wp_postmeta
SET meta_value = "1316"
INNER JOIN wp_posts ON wp_postmeta.post_id = wp_posts.ID
WHERE wp_posts.post_type="imagen_dia" AND wp_postmeta.meta_key="ae_post_template"

Any help please?

Which DBMS? Oracle? MySQL? SQL Server? ... The syntax for joined updates differs a lot in the various DBMS. Double quotes are for names by the way; use single quotes for strings. — Thorsten Kettner
– Thorsten Kettner, Commented Nov 20, 2017 at 20:11
Possible duplicate of MYSQL Update Statement Inner Join Tables — jmoerdyk
– jmoerdyk, Commented Nov 20, 2017 at 20:13

ScaisEdge · Accepted Answer · 2017-11-20 20:10:44Z

2

In mysql the JOIN should be before the set

UPDATE wp_postmeta
INNER JOIN wp_posts ON wp_postmeta.post_id = wp_posts.ID
SET meta_value = "1316"
WHERE wp_posts.post_type="imagen_dia" AND wp_postmeta.meta_key="ae_post_template"

answered Nov 20, 2017 at 20:10

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bob Over a year ago

THANKS A LOT!!! Now it works perfectly!! I was using sql all the time not knowing I have to use mysql. You saved my day. Thanks again my friend!! :)

Thorsten Kettner · Accepted Answer · 2017-11-20 20:14:52Z

1

The syntax for joined updates is vendor-specific. So do this without a join to have the update statement simple, readable and safe :-)

UPDATE wp_postmeta 
SET meta_value = '1316'
WHERE meta_key = 'ae_post_template'
AND post_id IN (SELECT id FROM wp_posts WHERE post_type = 'imagen_dia');

This statement is standard SQL and should work in about every RDBMS.

answered Nov 20, 2017 at 20:14

Thorsten Kettner

96.6k8 gold badges56 silver badges82 bronze badges

Comments

Matt Spinks · Accepted Answer · 2017-11-20 20:10:15Z

0

You are missing the FROM word:

UPDATE wp_postmeta
SET meta_value = "1316"
FROM wp_postmeta
INNER JOIN wp_posts ON wp_postmeta.post_id = wp_posts.ID
WHERE wp_posts.post_type="imagen_dia" AND wp_postmeta.meta_key="ae_post_template"

answered Nov 20, 2017 at 20:10

Matt Spinks

6,7404 gold badges32 silver badges57 bronze badges

Collectives™ on Stack Overflow

SQL syntax error INNER JOIN

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related