Error while creating procedure

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

On Thu, 08 Nov 2007 21:50:31 -0800,
satyendrakumarpandit@gmail.com wrote:

>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

Please show us the statements you are using to define the
procedure. I mean, the complete definition, not just the
procedure body.
--
( Kees
)
c[_] If I'm supposed to live every day like it's my
last, I want a gallon of morphine. (Russ Wallace) (#393)