CODE EXAMPLE FOR SQL

copy data from cell to cell mysql

update mytable set column1 = (select column1 from (select column1 from mytable where id = 2) as alias) where id = 5;