1

Reading the documentation

Single-table UPDATE assignments are generally evaluated from left to right. For multiple-table updates, there is no guarantee that assignments are carried out in any particular order.

I can't figure out if "evaluation" is the same as "assignment"

set col1 = (@v := col1) + 1, col2 = @v

In a multiple-table update, will col2 always have the original value of col1?

Improve this question
1
  • I read that documentation as a clear statement that one should not rely on the order of evaluation. Commented Apr 13, 2022 at 13:01
Related questions
2
Multi-table Update(MySQL)
1
MySQL Update a column depending on multi tables
2
MySQL: Update multiple tables with different column names?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.