mysql - 在 PHPmyadmin 中运行 SQL 查询时出错

Question

表架构:

Employee (empid, emp_name, age, DOB, designation, doj, basic_salary, salary_amt, medical_allowance, pension, GPFund, TA, House_allowance)
Monthly_salary (id, empid, year, month, total_salary)  

查询:

UPDATE `monthly_salary` 
     SET `total_salary`=`employee`.'salary_amt' -`employee`.'medical_allownces' - `employee`.'pension' 
     WHERE `employee`.'empid'=`monthly_salary`.'emp_id'

我正在尝试在 phpmyadmin 中运行此查询，但它没有运行并给出错误。员工 empid 用作月薪表中的外键。

Answer 1

删除单个 qoutes '

看起来应该像这样

UPDATE `monthly_salary` salary
JOIN    `employee`      employee    ON employee.empid=salary.emp_id
SET     salary.total_salary=employee.salary_amt - employee.medical_allownces - employee.pension

我给了表别名，使其更易于阅读。