There are content and contentvalues . It is necessary to copy data from one table to another. The DB is one, but the columns are different.

From the content table, the rows whose ID are equal to content_id in the contentvalues table, copy the content.longtitle field to the contentvalues.value field. Modify only strings whose tmplvarid is 13.

Did so, but gives an error:

 update contentvalues, content set contentvalues.value=content.longtitle where contentvalues.tmplvarid=13;

    1 answer 1

     merge into contentvalues cval using content src on (cval.content_id = src.id) when matched then update set cval.value = src.longtitle where cval.tmplvarid = 13 ;

    You can add - when not matched then insert ... if you suspect that the line does not exist yet.