stored procedures

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

stored procedures

Postby estudiante » 08. May 2009 10:50

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?
estudiante
 
Posts: 15
Joined: 04. May 2009 10:08

problem solved

Postby estudiante » 08. May 2009 13:26

I think the mistake was to write END$$ in spite of writing END $$ .
estudiante
 
Posts: 15
Joined: 04. May 2009 10:08


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 3 guests