Update from Select MySQL

UPDATE users AS U1, users AS U2

SET U1.name_one = U2.name_colX

WHERE U2.user_id = U1.user_id

Tags: , ,

Leave a Reply

You must be logged in to post a comment.