从mysql中的另一列更新一个派生值的列

I am trying to update the value of a column from another column in the same tabl e- but this fails with " ERROR 1093 (HY000): You can't specify target table 'tab_1' for update in FROM clause " I am trying to update the value of a column fro