phpMyAdmin Adding stored Procedures

phpMyAdmin Adding a stored procedure

Stored procedures:

?

CREATE PROCEDURE ' Clearcoupon ' () BEGIN declare today int (16);          Select Unix_timestamp (Curdate ()) into today; UPDATE coupon SET status=0 WHERE endtime
 
  
?

  
Copy to phpMyAdmin inside execution, the error is

  

  
Error

  
SQL query:

  
CREATE?PROCEDURE?' Clearcoupon '?(?)?BEGIN?Declare?Today?INT(? -?)?;


  
MySQL return:

  #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?
  

  

  


  
Workaround:

  
The syntax of the stored procedure is correct, and the problem is the statement specifier ";"

  
Just change the "statement qualifier" below the phpMyAdmin SQL input box to "//" to OK.

  

  


  
?
 
  
