Mysql update from select syntax error

Question

Query

I'm trying to executing the below query but in my phpmyadmin says

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM eest_estimated_total pet INNER JOIN eest_total pt ON pt.OrderNo = pet.Order' at line 1

UPDATE eest_estimated_total 
SET pet.Freight = pt.FrieghtCost, pet.CustomDuty = pt.ImportDuty 
FROM eest_estimated_total pet 
INNER JOIN eest_total pt 
ON pt.OrderNo = pet.OrderNo 
WHERE pt.OrderNo = pet.OrderNo

So may i know where im doing wrong ?

looks fine, change `UPDATE eest_estimated_total ` to `UPDATE pet` — Murad Hasan, Apr 04 '16 at 05:52

Giorgos Betsos · Accepted Answer · 2016-04-04T06:38:04.073

1

Try this way:

UPDATE pipo_estimated_total AS pet
INNER JOIN pipo_total AS pt 
ON pt.OrderNo = pet.OrderNo 
SET pet.Freight = pt.FrieghtCost, pet.CustomDuty = pt.ImportDuty   
WHERE pt.OrderNo = pet.OrderNo

edited Apr 04 '16 at 06:38

answered Apr 04 '16 at 05:52

Giorgos Betsos

71,379
9
63
98

@QuestionUser Sorry, I included a `FROM` clause which is not used in mysql – Giorgos Betsos Apr 04 '16 at 06:39

score 0 · Answer 2 · edited Apr 04 '16 at 06:38

0

Run This Query :-

UPDATE pipo_estimated_total 
SET pet.Freight = pt.FrieghtCost, pet.CustomDuty = pt.ImportDuty 
FROM pipo_estimated_total AS pet 
INNER JOIN pipo_total pt 
ON pt.OrderNo = pet.OrderNo 
WHERE pt.OrderNo = pet.OrderNo

edited Apr 04 '16 at 06:38

Murad Hasan

9,565
2
21
42

answered Apr 04 '16 at 05:53

user3305857

1
2

score 0 · Answer 3 · edited May 23 '17 at 11:45

0

As the answer says: update-from-select-using-sql-server

UPDATE
    Table_A
SET
    Table_A.col1 = Table_B.col1,
    Table_A.col2 = Table_B.col2
FROM
    Some_Table Table_A
INNER JOIN
    Other_Table Table_B
ON
    Table_A.id = Table_B.id
WHERE
    Table_A.col3 = 'cool'

Your Answer:

UPDATE pet
SET pet.Freight = pt.FrieghtCost, pet.CustomDuty = pt.ImportDuty 
FROM eest_estimated_total pet 
INNER JOIN eest_total pt 
ON pt.OrderNo = pet.OrderNo 
WHERE pt.OrderNo = pet.OrderNo

edited May 23 '17 at 11:45

Community

1
1

answered Apr 04 '16 at 05:54

Murad Hasan

9,565
2
21
42

1

This may be valid for Sql Server, but it's not valid for MySQL – Giorgos Betsos Apr 04 '16 at 06:40

Mysql update from select syntax error

3 Answers3