blob: b6b00420017ded2267be5acbf6c444e65b687e63 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
drop procedure if exists spUpdateFlags;
delimiter $$
create procedure spUpdateFlags(imgPath varchar(255))
begin
update `nationality` as `A`
set `A`.`flag` = (
select load_file(concat(imgPath, `country`, ".png")) as `flag`
from `nationality` as `B`
where `B`.`ID` = `A`.`ID`);
end$$
delimiter ;
|