SELECT idPolice,numeroPolice,idCollege,idAdherent,numeroAdherent,numeroBeneficiaire,
nomBeneficiaire,prenomsBeneficiaire,codeLienParente,sexe
FROM beneficiaire
-- WHERE numeroAdherent="02040052"
WHERE numeroBeneficiaire="0204005201" 


SELECT idPolice,numeroPolice,idCollege,idAdherent,numeroAdherent,numeroBeneficiaire,
nomBeneficiaire,prenomsBeneficiaire,codeLienParente,sexe
FROM beneficiaire
WHERE idPolice=62


SELECT * FROM police WHERE numeroPolice=22000044

-- numeroBeneficiaire="0229134102" 

SELECT idPolice,id,codeProduit,codeCollegeType,libelleCollege  FROM college WHERE idPolice=204

-- 1 -- idAdherent
-- 2 -- idCollege
-- 3 -- user 


-- recherche

SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204005201"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204001201"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003701"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003301"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204005001"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204001301"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003101"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204004301"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204004201"

SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204004001"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003901"

SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204001601"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003801"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204005101"
SELECT idPolice,idAdherent FROM beneficiaire WHERE numeroBeneficiaire="0204003401"


-- MODIDICATION DU COLLEGE AVEC LES DEPENSES
CALL sp_changer_collegeCourant(8278,360,'lionel');
CALL sp_changer_collegeCourant(9656,360,'lionel');
CALL sp_changer_collegeCourant(9643,360,'lionel');
CALL sp_changer_collegeCourant(6133,360,'lionel');
CALL sp_changer_collegeCourant(9644,360,'lionel');
CALL sp_changer_collegeCourant(9645,360,'lionel');
CALL sp_changer_collegeCourant(9647,360,'lionel');
CALL sp_changer_collegeCourant(9648,360,'lionel');
CALL sp_changer_collegeCourant(7086,360,'lionel');
CALL sp_changer_collegeCourant(6143,360,'lionel');
CALL sp_changer_collegeCourant(9655,360,'lionel');
CALL sp_changer_collegeCourant(9657,360,'lionel');
CALL sp_changer_collegeCourant(6150,360,'lionel');
CALL sp_changer_collegeCourant(9312,360,'lionel');
CALL sp_changer_collegeCourant(7097,360,'lionel');
