我刚学习使用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 3Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Error 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 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
我使用的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 3Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Error 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 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
BEGIN
SELECT * FROM mytest;
END$$DELIMITER ;
mysql> CREATE PROCEDURE ttt()
-> BEGIN
-> SELECT * FROM mytest;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)mysql> select version();
-> //
+------------------+
| version() |
+------------------+
| 5.1.34-community |
+------------------+
1 row in set (0.00 sec)mysql>
结贴了.....