syntax error 'from' identifier is not valid input at this position

Question

UPDATE dondathang
SET noigiaohang=diachi
FROM khachhang
WHERE dondathang.makhachhang=khachhang.makhachhang AND noigiaohang IS NULL;

I have a SQL code like above, but this is the error.

syntax error 'from' identifier is not valid input at this position.

What's wrong with my code?

Facundo Larrosa · Accepted Answer · 2018-06-19 03:35:45Z

1

FROM clause is irrelevant in UPDATE sintax. Please take a look at the documentation.

answered Jun 19, 2018 at 3:35

Facundo Larrosa

3,3892 gold badges16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DJo · Accepted Answer · 2018-06-19 09:19:07Z

0

FROM Clause is not a part of UPDATE syntax, you can change the UPDATE as below

UPDATE dondathang
SET noigiaohang=diachi
JOIN khachhang ON dondathang.makhachhang=khachhang.makhachhang
WHERE noigiaohang IS NULL;

answered Jun 19, 2018 at 9:19

DJo

2,1834 gold badges30 silver badges48 bronze badges

Gordon Linoff · Accepted Answer · 2018-06-19 11:50:07Z

0

The correct syntax in MySQL is:

UPDATE dondathang d JOIN
       khachhang k
       ON d.makhachhang = k.makhachhang
    SET d.noigiaohang = k.diachi
WHERE d.noigiaohang IS NULL;

answered Jun 19, 2018 at 11:50

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges