C3F2

(2)
update db_mesure set mes_valeur=1.0073, mes_incertitude_sur_valeur=0.0262 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.1364);
update db_mesure set mes_valeur=1.0319, mes_incertitude_sur_valeur=0.0231 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.2879);
update db_mesure set mes_valeur=1.0228, mes_incertitude_sur_valeur=0.021 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.4394);
update db_mesure set mes_valeur=1.0127, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.5909);
update db_mesure set mes_valeur=1.0136, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.7424);
update db_mesure set mes_valeur=1.0167, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.8939);
update db_mesure set mes_valeur=1 , mes_incertitude_sur_valeur=0.022 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.0455);
update db_mesure set mes_valeur=0.9919, mes_incertitude_sur_valeur=0.022 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.197 );
update db_mesure set mes_valeur=1.0016, mes_incertitude_sur_valeur=0.023 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.3485);
update db_mesure set mes_valeur=1.0212, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.5 );
update db_mesure set mes_valeur=1.0344, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.6515);
update db_mesure set mes_valeur=1.0012, mes_incertitude_sur_valeur=0.024 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.803 );
update db_mesure set mes_valeur=0.9954, mes_incertitude_sur_valeur=0.024 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.9546);
update db_mesure set mes_valeur=1.0019, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.1061);
update db_mesure set mes_valeur=0.9779, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.2576);
update db_mesure set mes_valeur=0.9967, mes_incertitude_sur_valeur=0.026 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.4091);
update db_mesure set mes_valeur=0.9918, mes_incertitude_sur_valeur=0.026 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.5606);
update db_mesure set mes_valeur=0.9742, mes_incertitude_sur_valeur=0.027 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.7121);
update db_mesure set mes_valeur=0.9791, mes_incertitude_sur_valeur=0.029 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.8636);
update db_mesure set mes_valeur=1.0285, mes_incertitude_sur_valeur=0.031 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.0152);
update db_mesure set mes_valeur=0.9193, mes_incertitude_sur_valeur=0.031 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.1667);
update db_mesure set mes_valeur=0.9079, mes_incertitude_sur_valeur=0.034 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.3182);
update db_mesure set mes_valeur=0.9903, mes_incertitude_sur_valeur=0.042 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.4697);
update db_mesure set mes_valeur=1.1074, mes_incertitude_sur_valeur=0.0998 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.6212);
update db_mesure set mes_valeur=1.0921, mes_incertitude_sur_valeur=0.1309 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.7727);

With check
select m.* from db_article natural join db_mesure m where art_fic_ref like 'Lachniet%' order by obs_id;
select o.*, a.art_fic_ref from db_article a natural join db_mesure m natural join db_observable o where m.obs_id between 113 and 138 order by obs_q_carre;

(3) last insert

@
insert into db_observable (obs_id, par_id, obs_q_carre, obs_signe_q_carre, obs_type_observable)
values (601, 0, 0.9848, 'SPACE LIKE', 'MAGNETIC');
select obs_id from db_observable where par_id = 0 and obs_q_carre = 0.9848 and obs_signe_q_carre = 'SPACE LIKE' and obs_type_observable = 'MAGNETIC';

select max (mes_id) from db_mesure ;
max
-----
770

insert into db_mesure (mes_id, art_id, fic_id, obs_id, mes_incertitude_sur_q_carre, mes_valeur, mes_incertitude_sur_valeur)
values (771, 49, 7, 601, 0, 0.9953, 0.0239);
@