mysql - 我可以用一个查询更新两个相同的表吗 - MySQL

Question

我可以用一个查询更新两个相同的表吗？

TABLEA
_____________________________
|     id      |   value     |
|_____________|_____________| 
|      1      |      a      | 
|      2      |      b      | 
|      3      |      c      | 
|      4      |      d      | 
|      5      |      e      |    
|_____________|_____________| 

TABLEB
_____________________________
|     id      |   value     |
|_____________|_____________| 
|      1      |      a      | 
|      2      |      b      | 
|      3      |      c      | 
|      4      |      d      | 
|      5      |      e      |    
|_____________|_____________| 

我想同时更新两个表(SET value = 'z' WHERE id=3)。这可能吗？

-谢谢

Answer 1

通过阅读 mysql update reference，它说:

For the multiple-table syntax, UPDATE updates rows in each table named in table_references that satisfy the conditions. In this case, ORDER BY and LIMIT cannot be used.

UPDATE items,month SET items.price=month.price WHERE items.id=month.id;

http://dev.mysql.com/doc/refman/5.0/en/update.html