Mysql Query - Subquery returns more than 1 row error

Question

I have a table resources (title, resourceid) and another table classifications (title, resourceid, classificationid)

I want to add the tiles from resources to the classification table, there are multiple rows with same resourceid in classifications.

When I wrote this query

update `classification` 
set `title`= (select title 
              from Resources 
              where Resources.`resourceid` = classification.`resourceid`)

I got this error:

Error - subquery returns more than 1 row.

Hack Saw · Accepted Answer · 2011-01-07 06:19:36Z

1

Try grouping the subquery by title, i.e.:

UPDATE classification SET title=(SELECT title FROM Resources
    WHERE Resources.resourceid=classification.resourceid GROUP BY title);

answered Jan 7, 2011 at 6:19

Hack Saw

2,7911 gold badge21 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Mysql Query - Subquery returns more than 1 row 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