I wanted to do add a new column to a table and to copy the values from that a diferent to column ( from the same table ) to the new column. And even though i thought of very integrates query’s at first, the solution was quite simple ( as always ).
ALTER TABLE `table_name` ADD `new_column` TEXT NOT NULL;
UPDATE `table_name` SET `new_column` = `old_column`;
Nice and simple.