复制表更改值的1列并将其插入到同一表中

试试这个

INSERT CustomerTable(customer, Field2, Field3, Field4)SELECt 123457, Field2, Field3, Field4from CustomerTableWHERe customer = 123456