²ËÄñ,¹ØÓÚÔÚMYSQLÖÐʹÓô洢¹ý³ÌÓöµ½µÄÎÊÌâ

ÎÒ¸ÕѧϰʹÓÃMYSQLÊý¾Ý¿â,֮ǰʹÓùýMSSQLÊý¾Ý¿â
ÎÒʹÓõÄMYSQL°æ±¾ÊÇ5.1.36
µ±ÎÒÔÚSQLyog 8.1°æÖÐдÁËÒ»¸öºÜ¼òµ¥µÄ´æ´¢¹ý³Ì,³öÏÖ´íÎó....Çë´ó¼Ò°ïæ½â¾öһϠлл

CREATE PROCEDURE ttt()
BEGIN
SELECT * from mytest;
END;
-------´íÎóÈçÏÂ---------
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time    : 00:00:00:000

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end' at line 1

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time    : 00:00:00:000

---

DELIMITER $$

CREATE PROCEDURE `test`.`ttt`()
        BEGIN
SELECT * from mytest;
    END$$

DELIMITER ;

---

²»»á°¡

SQL code:
mysql> delimiter //
mysql> CREATE PROCEDURE ttt()
-> BEGIN
-> SELECT * from mytest;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> select version();