phpMyAdmin平添預存程序

phpMyAdmin添加預存程序

預存程序:

?

CREATE PROCEDURE `ClearCoupon`()BEGIN     declare today int(16);            select UNIX_TIMESTAMP(curdate()) into today;          UPDATE coupon SET status=0 WHERE endtime
?
?copy到phpmyadmin裡面執行,就報錯了
錯誤
SQL 查詢:
CREATE?PROCEDURE?`ClearCoupon`?(?)?BEGIN?declare?today?INT(?16?)?;

MySQL 返回：
#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?

解決辦法:
預存程序的文法是沒錯的,出問題的是 語句界定符";"
只需要把phpmyadmin的sql輸入框下面的 "語句界定符"改為"//"就OK了

?
