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

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