Stored procedure not working

[vinoindiamca]

Hi please help in this

I written stored procedure through phpmyadmin it give error

create procedure sp_validation2(in u varchar(100), out a varchar(500))

begin

select address into a from booking where name=u;

END

 

Error:

 

Error

 

SQL query: Documentation

 

CREATE PROCEDURE sp_validation2( IN u varchar( 100 ) , out a varchar( 500 ) ) BEGIN SELECT address

INTO a

FROM booking

WHERE name = u;

 

MySQL said: Documentation

#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 '' at line 3

 

 

Please help me

[fenway]

Don't double post.