Hello.
Perhaps you've caught a server crash. Check error log. See: http://dev.mysql.com/doc/refman/5.0/en/Error_log.html Ligaya Turmelle wrote: > 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; // > > > ------------------------------------------------------------------------ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
