Trouble creating stored procedure

Posted by MatW on Stack Overflow See other posts from Stack Overflow or by MatW
Published on 2010-05-12T16:34:58Z Indexed on 2010/05/12 16:44 UTC
Read the original article Hit count: 236

I'm messing around with stored procedures for the first time, but can't even create a simple select! I'm using phpMyAdmin and this is my SQL:

DELIMITER // 
CREATE PROCEDURE test_select() 
BEGIN 
SELECT * FROM products LIMIT 10; 
END // 
DELIMITER ;

After submitting that, my localhost does some thinking for a loooong time and eventually loads a page with no content called /phpmyadmin/import.php. After reloading phpMyAdmin and trying to invoke the procedure:

CALL test_select();

I get a "PROCEDURE doesn't exist" error. Any ideas?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about stored-procedures