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