UPDATE
`book_info` b,
(SELECT
i.*
FROM
`book_tree` t
LEFT JOIN `book_info` i
ON t.`book_id` = i.`id`
WHERE t.`two_level_id` = 5) t1
SET
b.`with_file_type_name` = 5
WHERE b.`id` = t1.id
核心是 update 表1 表2
UPDATE
`book_info` b,
(SELECT
i.*
FROM
`book_tree` t
LEFT JOIN `book_info` i
ON t.`book_id` = i.`id`
WHERE t.`two_level_id` = 5) t1
SET
b.`with_file_type_name` = 5
WHERE b.`id` = t1.id
核心是 update 表1 表2