MySQL update query between two tables
UPDATE userphotos p, useralbums a
SET p.albumid = a.albumid
WHERE
a.userid = p.userid
AND a.album_name = “My Photos”
AND p.albumid = 0
http://stackoverflow.com/questions/4984646/mysql-update-query-between-two-tables
:max_bytes(150000):strip_icc():format(webp)/Modo-Seguro-Windows10-56aa12af3df78cf772ac45f3.png)