MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TEMPORARY TABLE temtable (
  `id` INTEGER,
  `salary` INTEGER
);

INSERT INTO temtable
  (`id`, `salary`)
VALUES
  ('1', '300'),
  ('2', '400'),
  ('3', '200'),
  ('4', '100');

Records: 4  Duplicates: 0  Warnings: 0


CREATE TABLE origtable (
  `id` INTEGER,
  `salary` INTEGER
);

INSERT INTO origtable
  (`id`, `salary`)
VALUES
  ('1', '100'),
  ('2', '200'),
  ('3', '400'),
  ('4', '300');

Records: 4  Duplicates: 0  Warnings: 0


UPDATE origtable o
INNER JOIN  temtable t ON t.id = o.id
SET o.salary = t.salary

Rows matched: 4  Changed: 4  Warnings: 0


SELECT * FROM origtable


id
salary


1
300

2
400

3
200

4
100


DROP TABLE temtable