Updating a table using another table Error in query [duplicate]

Question

This is my query

UPDATE ludo_purchase_detailed_history 
SET fto_date = logs_20221002.fto_date 
FROM logs_20221002 
WHERE ludo_purchase_detailed_history.uid= logs_20221002.uid;

This is the error I am getting

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM logs_20221002 WHERE ludo_purchase_detailed_history.uid= logs_20221002.uid' at line 1

Please help me. If anyone know what I am doing wrong here.

In MySQL there is no FROM clause in UPDATE syntax. Read the Reference Manual, "Multiple-table UPDATE syntax" carefully. — Akina
– Akina, Commented Oct 6, 2022 at 6:32
@nikhilsugandh I take refrence from this stackoverflow.com/questions/224732/… I want to update a table column using another table — Sahil
– Sahil, Commented Oct 6, 2022 at 6:42

juergen d · Accepted Answer · 2022-10-06 06:51:48Z

1

MySQL has a different syntax than MSSQL

UPDATE ludo_purchase_detailed_history h
JOIN logs_20221002 l ON h.uid = l.uid
SET h.fto_date = l.fto_date

answered Oct 6, 2022 at 6:51

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Collectives™ on Stack Overflow

Updating a table using another table Error in query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related