"from" is not valid at this position, expecting: EOF, ";"

Question

I try to increase John Smith salary by 10% and assume I don't know the emp_number for John Smith.

update m
    set m.mon_hourly_pay_rate = m.mon_hourly_pay_rate*1.1
from monthly_pay m
inner join Employee e
    on e.emp_number=m.emp_number
where e.emp_name = "John Smith";

Could anyone please help me. the word from have a red underline said "from" is not valid at this position, expecting: EOF, ";" but i google it and have not thing wrong with it

Which dbms are you using? `UPDATE ... FROM` is product specific functionality. — jarlh, Aug 30 '19 at 14:13
*"MySQLWorkbench"* is not a DBMS, this is a tool used to manage MySQL DBs — Cid, Aug 30 '19 at 14:17
Syntax for MySQL is different in case of update. `update.. from` does not work in MySQL — Madhur Bhaiya, Aug 30 '19 at 14:20

score 5 · Accepted Answer · answered Aug 30 '19 at 14:19

5

Your syntax is not correct. You need to use MySQL syntax as -

update monthly_pay m
       inner join Employee e
       on e.emp_number=m.emp_number
set m.mon_hourly_pay_rate = m.mon_hourly_pay_rate*1.1
where e.emp_name = "John Smith";

answered Aug 30 '19 at 14:19

Ankit Bajpai

13,128
4
25
40

"from" is not valid at this position, expecting: EOF, ";"

1 Answers1