MySQL 8.0

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

CREATE TABLE table1 (
  id INT,
  dep INT,
  cash INT,
  advance INT
);
INSERT INTO table1 VALUES
  (1, 100, 100, 200),
  (2, 200, 300, 500);
CREATE VIEW view_name AS SELECT *, advance / dep AS ratio FROM table1;
SELECT * FROM view_name;


id
dep
cash
advance
ratio


1
100
100
200
2.0000

2
200
300
500
2.5000


UPDATE table1 SET dep = 200 WHERE id = 1;
SELECT * FROM view_name;


id
dep
cash
advance
ratio


1
200
100
200
1.0000

2
200
300
500
2.5000