sql - MySQL UPDATE and SELECT from same table in subquery ...

2010年1月29日 - http://www.xaprb.com/blog/2006/06/23/how-to-select-from-an-update-target-in- mysql/ is the best resource I know on that subject.

stackoverflow.com