建立视图实发工资mysql

数据运维 2023-08-02 大白菜程序猿手机阅读

建立视图是MySQL数据库中非常重要的一个功能，它可以为用户提供更加方便的数据查询和管理方式。下面我们针对实发工资表，演示如何建立一个视图。

CREATE VIEW v_salary AS SELECT a.employee_id, a.name, a.basic_salary, a.social_security, a.housing_fund, (a.basic_salary + a.social_security + a.housing_fund) AS total_salary, (a.basic_salary + a.social_security + a.housing_fund - b.deduction) AS actual_salary FROM t_salary AS a LEFT JOIN t_deduction AS b ON a.employee_id = b.employee_id;