-- Script concatenar nombres de familia en un solo campo
-- 2017-03-06 
-- Fernando Salas
SET SQL_SAFE_UPDATES=0;
update family set
 first_surname_fml=concat(first_surname_fml,' ',last_surname_fml) where last_surname_fml is not null;
 update family set last_surname_fml=null;
 SET SQL_SAFE_UPDATES=1;