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?