blob: 434321041eb947294e03da76be88e12553b8d2aa (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
drop function if exists udfTotalDistance;
delimiter $$
create function udfTotalDistance(raceID int)
returns int
begin
return (
select `circuit`.`length` * `circuit`.`laps`
from `circuit`
inner join `racedatecircuit` on `racedatecircuit`.`circuitID` = `circuit`.`ID`
inner join `racedate` on `racedate`.`ID` = `racedatecircuit`.`raceDateID`
inner join `race` on `race`.`raceDateID` = `racedate`.`ID`
where `race`.`ID` = raceID);
end$$
delimiter ;
|