UPDATE emp_update1
   SET emp_name = CONCAT(emp_name, '2'),
       salary = salary + 100;

SELECT *
  FROM emp_update1;