Help for this page

Select Code to Download


  1. or download this
    my $SQL1 = q{
SET @t_id:=(SELECT Team_ID FROM Teams WHERE Name='Boston');
SELECT * FROM Games WHERE Team_ID=@t_id AND Date>'2012-05-01';
};
  2. or download this
    my $SQL2 = "
SET @t_id:=(SELECT Team_ID FROM Teams WHERE Name='Boston');
...
SET @t_id:=(SELECT Team_ID FROM Teams WHERE Name='Boston');
SELECT * FROM Games WHERE Team_ID=@t_id AND Date>'2012-05-01';
EOSQL