1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| -- Remplissage de la table GENE
INSERT INTO GENE (qualifier, name)
SELECT qualifier, name
FROM temp;
-- Remplissage de la table TYPE
INSERT INTO TYPE (type)
SELECT DISTINCT type_id
FROM temp;
-- Remplissage de la table DESCRIPTION
INSERT INTO DESCRIPTION (description)
SELECT DISTINCT description_id
FROM temp;
-- Remplissage de la table TYPER
INSERT INTO TYPER (t_gene_id, t_type_id)
SELECT g.gene_id, t.type_id
FROM GENE AS g
INNER JOIN temp AS t ON g.qualifier = t.qualifier
AND g.name = t.name
INNER JOIN TYPE AS ty ON ty.type = t.type
INNER JOIN DESCRIPTION AS d ON d.description = t.description |
Partager