Hi,
this is Satya here. I'm facing problem while creating a procedure in
mysql. I tried all the ways for creating a Procedure in MySql but its
always showing following error

Error: 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 'PROCEDURE a()BEGIN SELECT 'THIS' END
begin
select 'this'
end'

Here one thing is to note that error is being shown always to the
keyword "procedure" where ever server finds the keyword "procedure"
only there it shows the error. If it is in line one it will show error
in line 1 near the keyword 'Procedure' and so on. U can also note the
same thing in the Error I Posted.

See here though I've posted only one type but in all the ways I found
same Error.


Plz send the solution ASAP

Thanks
Satyendra