What will be right mysql syntax to copy a column data to another column

Question

I have table(mytable1) like-

Code Nombre 14 [:de]David[:en]Michel[:es]John[:] ... ....... ... ........

I have another table(mytable2) like-

Code Post_title

I want to copy data of column Nombre of mytable1 to Post_title column of mytable2.

See Is storing a delimited list in a database column really that bad? — eggyal
– eggyal, Commented Mar 4, 2015 at 18:44

Alex · Accepted Answer · 2015-03-04 18:59:38Z

1

UPDATE mytable2 LEFT JOIN mytable1 ON mytable1.code=mytable2.code SET mytable2.post_title = mytable1.nombre

answered Mar 4, 2015 at 18:59

17.3k1 gold badge31 silver badges52 bronze badges

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

1 Answer 1