42,7 → 42,7 |
|
Et effectuons une jointure sur bdtfx: |
SELECT id_observation, nom_sel, b.num_nom, b.famille |
FROM tb_cel.cel_obs c INNER JOIN tb_eflore.bdtfx_v1_02 b ON (b.nom_sci = c.nom_sel) |
FROM tb_cel.cel_obs c INNER JOIN tb_eflore.bdtfx_v1_01 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 tb_cel.cel_obs c INNER JOIN tb_eflore.bdtfx_v1_02 b ON (b.nom_sci = c.nom_sel) |
FROM tb_cel.cel_obs c INNER JOIN tb_eflore.bdtfx_v1_01 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 tb_cel.cel_obs c, tb_eflore.bdtfx_v1_02 b |
FROM tb_cel.cel_obs c, tb_eflore.bdtfx_v1_01 b |
WHERE ( |
b.nom_sci = c.nom_sel |
AND nom_sel IS NOT NULL AND nom_sel != '' |