title: Updating a table within a select statement
body: <p>Is there any way to update a table within  the select_expr part of a mysql select query. Here is an example of what I am trying to achieve:</p>
  
  <pre><code>SELECT id, name, (UPDATE tbl2 SET currname = tbl.name WHERE tbl2.id = tbl.id) FROM tbl;
  </code></pre>
  
  <p>This gives me an error in mysql, but I dont see why this shouldn't be possible as long as I am not changing tbl.</p>
  
  <p>Edit:
  I will clarify why I cant use an ordinary construct for this.</p>
  
  <p>Here is the more complex example of the problem which I am working on:</p>
  
  <pre><code>SELECT id, (SELECT @var = col1 FROM tbl2), @var := @var+1, 
  (UPDATE tbl2 SET col1 = @var) FROM tbl WHERE ...
  </code></pre>
  
  <p>So I am basically in a situation where I am incrementing a variable during the select statement and want to reflect this change as I am selecting the rows as I am using the value of this variable during the execution. The example given here can probably be implemented with other means, but the real example, which I wont post here due to there being too much unnecessary code, needs this functionality.</p>