SELECT * FROM 	beneficiaire	WHERE id=6873;  -- idPolice=156, idCollege=230,  idAdherent=2836, numeroAdherent='01560782',numeroBeneficiaire='0156078207'

SELECT * FROM 	beneficiaireavenant	WHERE idBeneficiaire=0;

SELECT * FROM 	beneficiaireprime	WHERE idBeneficiaire=0; UPDATE beneficiaireprime SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	carteassure	WHERE idBeneficiaire=0; UPDATE carteassure SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	etatbeneficiaire	WHERE idBeneficiaire=0;  UPDATE etatbeneficiaire SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	garantiebeneficiaire	WHERE idBeneficiaire=0; UPDATE garantiebeneficiaire SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	ged	WHERE idBeneficiaire=0;  UPDATE ged SET idBeneficiaire=6873,idPolice=156,idClient=140,idAdherent=2836 WHERE idBeneficiaire=0;

SELECT * FROM 	historiquereinitialiserfeuille	WHERE idBeneficiaire=0; UPDATE historiquereinitialiserfeuille SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	hp_ecartdecompte	WHERE idBeneficiaire=0;  UPDATE hp_ecartdecompte SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	limitebeneficiaire	WHERE idBeneficiaire=0;  UPDATE limitebeneficiaire SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	logenvoimail	WHERE idBeneficiaire=0;  UPDATE logenvoimail SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_bonpec	WHERE idBeneficiaire=0;  UPDATE p_bonpec SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_demandeententeprealable	WHERE idBeneficiaire=0;  UPDATE p_demandeententeprealable SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_demandeententeprealablepha	WHERE idBeneficiaire=0;  UPDATE p_demandeententeprealablepha SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_diagnostique	WHERE idBeneficiaire=0;  UPDATE p_diagnostique SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_ecartdecompte	WHERE idBeneficiaire=0;  UPDATE p_ecartdecompte SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_envoimail_copy	WHERE idBeneficiaire=0; UPDATE p_envoimail_copy SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_examen	WHERE idBeneficiaire=0;   UPDATE p_examen SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_facture	WHERE idBeneficiaire=0;   UPDATE p_facture SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_feuillemaladie	WHERE idBeneficiaire=0; UPDATE p_feuillemaladie SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_logenvoimail	WHERE idBeneficiaire=0;   UPDATE p_logenvoimail SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_miseenobservation WHERE idBeneficiaire=0;   UPDATE p_miseenobservation SET  idBeneficiaire=6873,idPolice=156,idAdherent=2836,numeroBeneficiaire='0156078207' WHERE idBeneficiaire=0;

SELECT * FROM 	p_optique	WHERE idBeneficiaire=0;  UPDATE p_optique SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_prescription	WHERE idBeneficiaire=0;  UPDATE p_prescription SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM 	p_prestationactes	WHERE idBeneficiaire=0; UPDATE p_prestationactes SET  idBeneficiaire=6873,idAdherent=2836, numeroAdherent='01560782',numeroBeneficiaire='0156078207' WHERE idBeneficiaire=0;

SELECT * FROM 	p_reglement	WHERE idBeneficiaire=0; UPDATE p_reglement SET  idBeneficiaire=6873,idAdherent=2836,numeroBeneficiaire='0156078207' WHERE idBeneficiaire=0;

SELECT * FROM 	r_dossier_classique	WHERE idBeneficiaire=0; UPDATE r_dossier_classique SET idBeneficiaire=6873 WHERE idBeneficiaire=0;

SELECT * FROM `user` WHERE idBeneficiaire=0;  UPDATE `user` SET idBeneficiaire=6873 WHERE idBeneficiaire=0;




