UPDATE:
This morning I attempted to create a stored procedure from Adobe's site, tutorial for stored procedures. I copied and pasted the code into SQL, the MySQL message stated that:
"Your SQL query has been executed successfully"
But when I called the SP, MySQL gives me the message that "it does not exist", and it is not listed when I run "show procedure status".
I am desperate as have projects due. Something must be screwed up, so I am just going to back everything up, and update XAMPP and MySQL, and hope it works.
XAMPP 1.7. 4 For Windows XP SP3, MySQL 5.1:
(1)I am getting squirrely, inconsistent results when I attempt to create a stored procedure. If I use this syntax:
DELIMITER //
CREATE PROCEDURE [nameofprocedure]()
BEGIN
SELECT *
FROM [table_name};
END//
DELIMITER ;
I get error messages. If I leave out the 'BEGIN' and 'END' and add 'DEFINER' as in next example, MySQL creates the SP.
CREATE DEFINER=`root`@`localhost`
PROCEDURE `sp-name`()
SELECT COUNT(ID)
FROM [table_name]
(2) Have not been successful calling a sp with parameters.
Has NE1 had this problem? Solution? Would appreciate NE help; like XAMPP v. much.
Guido T.