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: 288
        
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