Update query with multiple subqueries

Question

Here is the update I'm trying to run:

UPDATE  oc_product_gpf SET
brand =  '(select name from oc_manufacturer where manufacturer_id=
(select manufacturer_id from oc_product where product_id = oc_product_gpf.product_id) )'
WHERE  oc_product_gpf.gpf_id =2454;

The error I'm receiving is '#1406 - Data too long for column 'brand' at row 1'

Any suggestions? Thanks in advance!

that's not a subquery. it's a STRING containing some text that LOOKS like a query. but since it's a string, that "kinda looks like sql" is NOT executed. Remove the '. — Marc B
– Marc B, Commented Oct 19, 2016 at 15:50
See meta.stackoverflow.com/questions/333952/… and try to explain what you're actually trying to do. — Strawberry
– Strawberry, Commented Oct 19, 2016 at 15:56

user1881277 · Accepted Answer · 2016-10-19 15:52:22Z

2

Your subquery not acting as a subquery here. it simply act as a string and trying to assign to "brand" column. Please remove the '' or convert that in to a join

answered Oct 19, 2016 at 15:52

user1881277

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

Collectives™ on Stack Overflow

Update query with multiple subqueries

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