| 42,7 → 42,7 |
|---|
| |
| Et effectuons une jointure sur bdtfx: |
| SELECT id_observation, nom_sel, b.num_nom, b.famille |
| FROM `BASEEDIT`.`cel_obs` c INNER JOIN `BASESOURCE`.`bdtfx_v1_01` b ON (b.nom_sci = c.nom_sel) |
| FROM `BASEEDIT`.`cel_obs` c INNER JOIN `BASESOURCE`.`TABLEBDTFX` b ON (b.nom_sci = c.nom_sel) |
| WHERE ( |
| nom_sel IS NOT NULL AND nom_sel != '' |
| AND ( |
| 68,7 → 68,7 |
|---|
| |
| Nous obtenons donc ainsi les 69 observations à mettre à jour: |
| SELECT id_observation, nom_sel, nom_ret, nom_ret_nn, nt, c.famille, b.num_nom, b.nom_sci, b.num_taxonomique, b.famille |
| FROM `BASEEDIT`.`cel_obs` c INNER JOIN `BASESOURCE`.`bdtfx_v1_01` b ON (b.nom_sci = c.nom_sel) |
| FROM `BASEEDIT`.`cel_obs` c INNER JOIN `BASESOURCE`.`TABLEBDTFX` b ON (b.nom_sci = c.nom_sel) |
| WHERE ( |
| nom_sel IS NOT NULL AND nom_sel != '' |
| AND ( |
| 91,7 → 91,7 |
|---|
| |
| CREATE TEMPORARY TABLE T_bis ( INDEX(`id_observation`)) AS |
| SELECT id_observation, b.num_nom, CONCAT(b.nom_sci, ' ', b.auteur), b.num_taxonomique, b.famille |
| FROM `BASEEDIT`.`cel_obs` c, `BASESOURCE`.`bdtfx_v1_01` b |
| FROM `BASEEDIT`.`cel_obs` c, `BASESOURCE`.`TABLEBDTFX` b |
| WHERE ( |
| b.nom_sci = c.nom_sel |
| AND nom_sel IS NOT NULL AND nom_sel != '' |