Answer 1

You can use update query.

UPDATE table_name
SET newcolumn1=value1
WHERE condition;

For condition use corresponding a row value..

Why you included these unnecessary posts...
Pls remove all... Otherwise your question may become marked as mfd by mods