I dont know if this is possible.
something like
UPDATE t.1,t2 SET this=that WHERE t1.unique_id = t2.unique_id ect..
update with joins
Moderator: General Moderators
-
visionmaster
- Forum Contributor
- Posts: 139
- Joined: Wed Jul 14, 2004 4:06 am
Re: update with joins
Hello,
Yes, you can cross table delete as well as cross table update. Check out these links:
http://www.electrictoolbox.com/article/mysql
http://www.electrictoolbox.com/article/ ... le-update/
Example:
UPDATE product p
INNER JOIN productPrice pp
ON p.productId = pp.productId
SET pp.price = pp.price * 0.8
WHERE p.dateCreated < '2004-01-01'
Yes, you can cross table delete as well as cross table update. Check out these links:
http://www.electrictoolbox.com/article/mysql
http://www.electrictoolbox.com/article/ ... le-update/
Example:
UPDATE product p
INNER JOIN productPrice pp
ON p.productId = pp.productId
SET pp.price = pp.price * 0.8
WHERE p.dateCreated < '2004-01-01'