Procedury: if else, Syntax Error 1064 Opcje

[Garrett]

Witam
Chcę stworzyć sobie taką procedurkę, która sortuje wyniki w zależności od podanego parametru: 1 albo 2

[SQL] pobierz, plaintext 
CREATE PROCEDURE zad2(par1 int)
BEGIN
IF par1=1 then
SELECT Name, LANGUAGE, Percentage, Population, LifeExpectancy, floor(Population*(Percentage/100)) AS LudnoscMOWIACAjezykiem FROM country
JOIN countrylanguage ON ( countrylanguage.CountryCode=country.Code )
WHERE IsOfficial='T'
ORDER BY Name
 
ELSE
SELECT Name, LANGUAGE, Percentage, Population, LifeExpectancy, floor(Population*(Percentage/100)) AS LudnoscMOWIACAjezykiem FROM country
JOIN countrylanguage ON ( countrylanguage.CountryCode=country.Code )
WHERE IsOfficial='T'
ORDER BY LANGUAGE
END IF
END
[SQL] pobierz, plaintext 

I próbuję na różne sposoby wpisywać te BEGINY i ENDY, ale nadal wywala:

Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END

Gdzie jest błąd?

[kokers]

brakuje kilku średników no i w mysql trzeba jeszcze ustawić delimiter czyli coś takiego:

[SQL] pobierz, plaintext 
DELIMITER //
CREATE PROCEDURE zad2(par1 int)
BEGIN
IF (par1=1) then
SELECT Name, LANGUAGE, Percentage, Population, LifeExpectancy, floor(Population*(Percentage/100)) AS LudnoscMOWIACAjezykiem FROM country
JOIN countrylanguage ON ( countrylanguage.CountryCode=country.Code )
WHERE IsOfficial='T'
ORDER BY Name;
 
ELSE
 
SELECT Name, LANGUAGE, Percentage, Population, LifeExpectancy, floor(Population*(Percentage/100)) AS LudnoscMOWIACAjezykiem FROM country
JOIN countrylanguage ON ( countrylanguage.CountryCode=country.Code )
WHERE IsOfficial='T'
ORDER BY LANGUAGE;
 
END IF;
END //
DELIMITER ;
[SQL] pobierz, plaintext 

[Garrett]

Dzięki (IMG:style_emoticons/default/smile.gif)