viernes, 7 de agosto de 2015

MySQL - Update from one table to another based on a ID match

My SQL skills are close to NONE, I've struggled with this simple task more than I would like to accept. Hence, this first post.
UPDATE table1, table2
SET table1.columnA = table2.columnA,
table1.columnB = table2.columnB,
[...]
WHERE table1.id = table2.id

No hay comentarios:

Publicar un comentario