更新时子查询返回多行

Question

I am writing one simple SQL query to update my table .

here is my code

$qry = mysql_query("update product set cat_tree =(select cat_name from cat_details where product.category = cat_details.cat_id )");

When ever i tried to run this code its giving error message

#1242 - Sub query returns more than 1 row

What is the problem ? I tried with so many solutions like "IN" "ANY" . But all examples are for insert query only.

Thanks in advance

Answer 1

You should try LIMIT like this...

$qry = mysql_query("update product set cat_tree =(select cat_name from cat_details where product.category = cat_details.cat_id LIMIT 1)");