How can I dublicate the content of one table column into another column? :  This is my table "data":

    name  | descripton
    ======|===========
    lara  | 
    fred  |
    todd  |

I want to transfer now the content of my column "name" into my column "description":

    name  | descripton
    ======|===========
    lara  | lara 
    fred  | fred
    todd  | todd

This is my approach:

    update data
    SET description=(select name from data)

> #1093 - You can't specify target table 'story_category' for update in FROM clause