UPDATE `tb_album` SET `tb_album`.`sourcetype`=`tb_task`.`type` FROM `tb_album` ,`tb_task` WHERE `tb_album`.`id`=`tb_task`.`album_id` 这个是我自己写的,貌似是错误的,给个检疫大神、、们
UPDATE `tb_album` ,`tb_task` SET `tb_album`.`sourcetype` = `tb_task`.`type` WHERE `tb_album`.`id` = `tb_task`.`album_id`
update album, task set album.sourcetype = task.type where album.id = task.albumid
update album A INNER JOIN task B ON A.id = B.albumid set A.sourcetype = B.type
SET `tb_album`.`sourcetype`=`tb_task`.`type`
FROM `tb_album` ,`tb_task`
WHERE `tb_album`.`id`=`tb_task`.`album_id`
这个是我自己写的,貌似是错误的,给个检疫大神、、们
SET `tb_album`.`sourcetype` = `tb_task`.`type`
WHERE `tb_album`.`id` = `tb_task`.`album_id`
ON A.id = B.albumid
set A.sourcetype = B.type