SELECT * FROM p_prestationactes
WHERE  `numeroFeuilleMaladie`='88768'



SELECT * FROM p_feuillemaladie
WHERE numeroBonConsultation='89327'



SELECT * FROM `p_prestationacteshospitalisation`
WHERE numeroBeneficiaire='0242003901'


SELECT * FROM p_acte 
WHERE codeActe IN ('HHM','AC0001175','PHOSP')



SELECT * FROM hp_prestationactes WHERE numeroFeuilleMaladie="84394" AND codeTypePrestation="HOSP";

INSERT INTO `hp_prestationacteshospitalisation` 
SELECT * FROM p_prestationacteshospitalisation WHERE numeroFeuilleMaladie="84394";


DELETE FROM p_prestationacteshospitalisation WHERE numeroFeuilleMaladie="84394";

INSERT INTO `hp_prestationactes` SELECT * FROM p_prestationactes WHERE numeroFeuilleMaladie="84394" AND codeTypePrestation="HOSP";
DELETE FROM p_prestationactes WHERE FROM p_prestationactes WHERE numeroFeuilleMaladie="84394" AND codeTypePrestation="HOSP";

UPDATE p_feuillemaladie SET
	numeroBonHospitalisation = "0"
WHERE numeroFeuilleMaladie="84394";