Reprint: MySQL update updates the implementation of the tape query

Originating From: http://576017120.iteye.com/blog/1947154

When you update MySQL, you cannot directly update the table as a query table, which can be done in the form of a temporary intermediate table.

To summarize:

One: When a single table is updated

For example: Update customer Set category = 1 WHERE deleteflag = 0 and name = ' 22 ';

Be careful not to subquery, MySQL is not allowed.

II: Complex update of the tape query

Such as:

Update TB A,
(Select Time,name
From TT) b
Set Time4=b.col
where A.name=b.name and a.time1=b.time;

Updates can be made to multiple tables at update

such as: Update Ta a,tb b set a.bid=b.id, b.aid=a.id;

You can do any query after update, which is equivalent to from;

Reprint: MySQL update updates the implementation of the tape query