UPDATE problem

[piti]

i was using this code before i went to mysql

UPDATE Strom
SET Strom.Length = Top.Length
FROM
Strom
INNER JOIN Top ON Strom.IdAtr_00 = Top.IdAtr_00

this doesn't seem to be correct update syntax for mysql, then i'm getting error when running this code:

You have an error in your SQL syntax near 'FROM Strom INNER JOIN Top ON Strom.IdAtr...

table and column names are correct

anyone here who knows how to do the same on mysql?
thanks

 

[Cagliostro]

try
UPDATE Strom
SET Strom.Length = Top.Length
FROM
Top
where Strom.IdAtr_00 = Top.IdAtr_00 John Fill

ivfmd@mail.md

 

[piti]

as well as my code, this also doesn't work

i think the FROM clause in UPDATE cannot work as it is not mentioned in the documentation
am i right?