salix/db/routines/vn/procedures/ediTables_Update.sql

14 lines
295 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`ediTables_Update`()
BEGIN
INSERT IGNORE INTO vn.genus(name)
SELECT latin_genus_name
FROM edi.genus ;
INSERT IGNORE INTO vn.specie(name)
SELECT LCASE(latin_species_name)
FROM edi.specie ;
END$$
DELIMITER ;