UPDATE users AS U1, users AS U2
SET U1.name_one = U2.name_colX
WHERE U2.user_id = U1.user_id
Tags:mysql, select, update Posted in MySQL | No Comments »