CREATE TABLE fs_input1 AS SELECT * FROM fs_input; UPDATE fs_input1 SET am='manualsys' WHERE am='manual';