mysql - 更新左连接查询帮助

Question

我不知道如何做我想做的事。
希望在这个例子中展示了数据关系

UPDATE sym_entries_data_55'
SET value =  '46.00' 
WHERE (sym_entries_data_55.id = sym_entries_data_54.id)
AND (sym_entries_data_54.member_id = sym_entries_data_5.entry_id)
AND (sym_entries_data_5.username = 'namehere')

回答

UPDATE sym_entries_data_55, sym_entries_data_54, sym_entries_data_5
    SET sym_entries_data_55.value = '52.00'
    WHERE sym_entries_data_55.id = sym_entries_data_54.id
        AND sym_entries_data_54.member_id = sym_entries_data_5.entry_id
        AND sym_entries_data_5.username = 'namehere'

Answer 1

UPDATE sym_entries_data_55, sym_entries_data_54, sym_entries_data_5
    SET sym_entries_data_55.value = '46.00'
    WHERE sym_entries_data_55.id = sym_entries_data_54.id
        AND sym_entries_data_54.member_id = sym_entries_data_5.entry_id
        AND sym_entries_data_5.username = 'namehere'