problem creating a stored procedure in mysql 5

[fogofogo]

Hello,

 

I'm trying to create a stored procedure through phpmyadmin and its giving me an error. Heres my query...

 

DROP PROCEDURE IF EXISTS `LoginUser`

GO

 

CREATE PROCEDURE LoginUser(

IN p_Alias varchar(30)

 

)

 

BEGIN

 

SELECT FirstName  FROM users WHERE Alias = p_Alias;

 

END

 

GO

 

Its giving me an error saying ...

 

check the manual that corresponds to your MySQL server version for the right syntax to use near 'GO

 

Can anyone see the obvious error I'm making? Sorry I'm new to this.

 

Cheers

 

 

 

 

[fogofogo]

looks like I messed it up.

 

This fixed it

 

CREATE PROCEDURE LoginUsers(IN palias VARCHAR(30), OUT pFirstName VARCHAR(30))

BEGIN

SELECT FirstName INTO pFirstName FROM users WHERE Alias=palias;

END