UPDATE tSociosSMF
        SET claveSocio = 'SMF001'
        WHERE correo = 'rivas.patricia@inifap.gob.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF002'
        WHERE correo = 'gavilaq@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF003'
        WHERE correo = 'ees@unam.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF004'
        WHERE correo = 'rhizobac@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF005'
        WHERE correo = 'mlcr7@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF006'
        WHERE correo = 'qfb.ili.lara@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF007'
        WHERE correo = 'jc436@inlumine.ual.es'
UPDATE tSociosSMF
        SET claveSocio = 'SMF008'
        WHERE correo = 'ana.lopez@estudiantes.ciad.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF009'
        WHERE correo = 'guillermo.arsnl@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF010'
        WHERE correo = 'norma.avila@colpos.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF011'
        WHERE correo = 'gsantoyo@umich.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF012'
        WHERE correo = 'grandmend.mexico@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF013'
        WHERE correo = 'clopezorona@uas.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF014'
        WHERE correo = 'zevangelista@ciatej.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF015'
        WHERE correo = 'fdelgado@itcolima.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF016'
        WHERE correo = 'olgago@colpos.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF017'
        WHERE correo = 'esegundo@correo.xoc.uam.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF018'
        WHERE correo = 'corderogarcia92@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF019'
        WHERE correo = 'bio.h.salgado@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF020'
        WHERE correo = 'rodriguezgmf@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF021'
        WHERE correo = 'mohernandezl@ipn.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF022'
        WHERE correo = 'oalejandrovera@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF023'
        WHERE correo = 'vpdvargas@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF024'
        WHERE correo = 'marluz-rojas85@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF025'
        WHERE correo = 'ing.jcjm91@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF026'
        WHERE correo = 'aguilarolmos28@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF027'
        WHERE correo = 'chely.cortez@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF028'
        WHERE correo = 'j_velazquez2@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF029'
        WHERE correo = 'norawa@ciad.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF030'
        WHERE correo = 'eleazar.martinez@uabc.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF031'
        WHERE correo = 'gaby_andradeb@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF032'
        WHERE correo = 'patita_1390@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF033'
        WHERE correo = 'andrade.gabriela@uabc.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF034'
        WHERE correo = 'rosario.gregorio@posgrado.ecologia.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF035'
        WHERE correo = 'jqui@ciatej.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF036'
        WHERE correo = 'rsantillanm3734@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF037'
        WHERE correo = 'fernandaruiz_c@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF038'
        WHERE correo = 'claudio.rios@ciad.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF039'
        WHERE correo = 'cristina_montoya14@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF040'
        WHERE correo = 'danypinvac@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF041'
        WHERE correo = 'guero4646@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF042'
        WHERE correo = 'riveselene@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF043'
        WHERE correo = 'gvapon@colpos.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF044'
        WHERE correo = 'lukairo21@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF045'
        WHERE correo = 'egpineda@umich.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF046'
        WHERE correo = 'jmarmole@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF047'
        WHERE correo = 'famk22@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF048'
        WHERE correo = 'edgar_villarled@yahoo.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF049'
        WHERE correo = 'daniel.barcenas@colpos.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF050'
        WHERE correo = 'jet-lis19@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF051'
        WHERE correo = 'mari.93.cs@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF052'
        WHERE correo = 'grincon@ciatej.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF053'
        WHERE correo = 'equinones@ciatej.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF054'
        WHERE correo = 'eqaguilar08@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF055'
        WHERE correo = 'sergiodavidvale@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF056'
        WHERE correo = 'rgarciave@uaemex.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF057'
        WHERE correo = 'gusantoyo@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF058'
        WHERE correo = 'almarosa.solano@upaep.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF059'
        WHERE correo = 'afy.0495@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF060'
        WHERE correo = 'omaralvarado085@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF061'
        WHERE correo = 'gmarquezl@ipn.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF062'
        WHERE correo = 'marcocortes_r@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF063'
        WHERE correo = 'ucalber@yahoo.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF064'
        WHERE correo = 'lourdescervantes@uabc.ede.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF065'
        WHERE correo = 'lourdescervantes@uabc.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF066'
        WHERE correo = 'riquelme_124@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF067'
        WHERE correo = 'ade_phany@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF068'
        WHERE correo = 'alvarorene.leonardo@bayer.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF069'
        WHERE correo = 'frederique.reverchon@inecol.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF070'
        WHERE correo = 'yisosauach@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF071'
        WHERE correo = 'eyesnator@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF072'
        WHERE correo = 'biol.estefaniarmz@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF073'
        WHERE correo = 'alma_aoa75@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF074'
        WHERE correo = 'cortesjjm@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF075'
        WHERE correo = 'gonzalohl22@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF076'
        WHERE correo = 'guzman.h.eduardo@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF077'
        WHERE correo = 'nativitas89@colpos.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF078'
        WHERE correo = 'moises.camachotapia@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF079'
        WHERE correo = 'amichelaceves@yahoo.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF080'
        WHERE correo = 'urielmonarca@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF081'
        WHERE correo = 'nuriah@live.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF082'
        WHERE correo = 'angelagl_92@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF083'
        WHERE correo = 'acostagonzalezuri@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF084'
        WHERE correo = 'Sharahia96@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF085'
        WHERE correo = 'adigih@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF086'
        WHERE correo = 'ivan_leal94@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF087'
        WHERE correo = 'fuentes.davila@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF088'
        WHERE correo = 'eduhernav@icloud.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF089'
        WHERE correo = 'avilesofia@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF090'
        WHERE correo = 'jenriquez@ciatej.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF091'
        WHERE correo = 'ruhernan@cicese.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF092'
        WHERE correo = 'claudia.munoz@itcelaya.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF093'
        WHERE correo = 'romansandoval502@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF094'
        WHERE correo = 'benjaminreyna661@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF095'
        WHERE correo = 'romansandoval502@gmai.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF096'
        WHERE correo = 'crisp28@yahoo.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF097'
        WHERE correo = 'csoberano@umich.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF098'
        WHERE correo = 'Piscesrhapsody@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF099'
        WHERE correo = 'vallejo.pmr@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF100'
        WHERE correo = 'alinanaranjo@yahoo.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF101'
        WHERE correo = 'cdelgado@cicese.edu.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF102'
        WHERE correo = 'mcstephany_itsp@outlook.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF103'
        WHERE correo = 'cdelgado@cicese.edu.mzx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF104'
        WHERE correo = 'iris@ciad.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF105'
        WHERE correo = 'joanafernandez91@gmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF106'
        WHERE correo = 'slick_0508@hotmail.com'
UPDATE tSociosSMF
        SET claveSocio = 'SMF107'
        WHERE correo = 'annciencias@yahoo.com.mx'
UPDATE tSociosSMF
        SET claveSocio = 'SMF108'
        WHERE correo = 'yesili19nov@hotmail.com'
Listo