PhpMyAdmin additional storage process

PhpMyAdmin adds the stored procedure :? CREATEPROCEDURE 'clearupon' () BEGINdeclaretodayint (16); selectUNIX_TIMESTAMP (curdate () skip today; UPDATEcouponS phpMyAdmin add stored procedure

Stored Procedure:

?

Create procedure 'clearupon' () BEGIN declare today int (16); select UNIX_TIMESTAMP (curdate () into today; UPDATE coupon SET status = 0 WHERE endtime
 
  
?
  
? Copy to phpmyadmin and run the command. an error is returned.
  

  
Error
  
SQL query:
  
CREATE? PROCEDURE? 'Clearupon '? (?)? BEGIN? Declare? Today? INT (? 16 ?)?;


  
MySQL returns:
  #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?
  

  

  


  
Solution:
  
The syntax of the stored procedure is correct. what is wrong is the statement descriptor ";"
  
You only need to change the "statement delimiter" under the SQL input box of phpmyadmin to "//" to OK.
  

  


  
?