System - Windows XP SP2
Version - 5.0.15-nt
I just ran into some odd behavior with the mysqld on Windows XP... I am
learning about Stored procedures and went to copy and paste an example
provided in an article on dev.mysql.com
(http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html).
I forgot to "use db" before hand but remembered "DELIMITER //" (came
back to it after a break). When I went to create a stored procedure on
the command line the mysqld stopped running (after the full SQL was
input and enter hit). I had to manually restart it with "net start
mysql" on the command line. I repeated this a couple of times just to
see if it was a fluke - same thing happened every time. Is this
expected behavior?
Stored Procedure:
CREATE PROCEDURE p16 ()
BEGIN
DECLARE v INT;
SET v = 0;
loop_label: LOOP
INSERT INTO t VALUES (v);
SET v = v + 1;
IF v >= 5 THEN
LEAVE loop_label;
END IF;
END LOOP;
END; //
--
Respectfully,
Ligaya Turmelle
"Life is a game.... so have fun"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]