Page 1 of 1

stored procedures

PostPosted: 08. May 2009 10:50
by estudiante
Hi, I´m newbe and I´m trying to save a stored procedure using phpMyAdmin.

I thought it was as easy as writing:

******************************************************
-- Create myprocedure stored procedure
CREATE PROCEDURE myprocedure( )

BEGIN SELECT attribute1, attribute2
FROM mytable
ORDER BY attribute1;

END$$
******************************************************

But phpMyAdmin tells me there is a syntax problem in my sql-query. Is there something I´m not doing wright?

problem solved

PostPosted: 08. May 2009 13:26
by estudiante
I think the mistake was to write END$$ in spite of writing END $$ .