写脚本创建数据库报
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 1
真是百思不解啊!!!
原是创建存储过程需要用DELIMITER括起表示里面的内容是要一起执行的不能因为有;符号而分开执行。
下面是例子:
- DELIMITER //
- CREATE PROCEDURE p7 (IN b INTEGER(12))
- begin
- declare a INTEGER(12);
- set a=5;
- INSERT INTO t VALUES (a);
- SELECT s1*a FROM t WHERE b<=s1;
- End
- //