Hi all,
I wanna try the following query,
=============================================
select concat(
"update product set price=",
p2.price,
" where id=",
p1.id,
";"
)
from product p1 left join product p2
on p1.name=p2.name
where p1.price = 0 and p2.price>0;
=============================================
I am able to get the update statements properly,
but unfortunately my table(no single rows)
was not updated really.
I am using mysql 3.22.32.
am i doing anything wrong.?
vanakkam,
-malkova
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
