phpmyadmin update query using 3 tables in giving error

Question

I am getting the following Error

064 - 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 'from catalog_product_flat_1 a inner join catalog_product_entity c on a.sku' at line 3

when I try out the below query on phpmyadmin

update a 
set a.small_image = b.value
from `catalog_product_flat_1` a
inner join `catalog_product_entity` c
on a.sku = c.sku
inner join `catalog_product_entity_media_gallery` b
on b.entity_id = c.entity_id

I also tryout without using alias but still same issue

Barmar · Accepted Answer · 2013-06-30 11:40:10Z

1

The SET clause comes after the JOIN clauses:

UPDATE `catalog_product_flat_1` a
inner join `catalog_product_entity` c
on a.sku = c.sku
inner join `catalog_product_entity_media_gallery` b
on b.entity_id = c.entity_id
SET a.small_image = b.value

See the documenation:

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

answered Jun 30, 2013 at 11:40

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

phpmyadmin update query using 3 tables in giving error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related