phpMyAdmin平添存储过程

phpMyAdmin添加存储过程存储过程:?错误SQL 查询:CREATE?PROCEDURE?`ClearCoupon`?(?)?BEGIN?declare?today

phpMyAdmin添加存储过程

存储过程:

?

错误

SQL 查询:

CREATE?PROCEDURE?`ClearCoupon`?(?)?BEGIN?declare?today?INT(?16?)?;

MySQL 返回:phpMyAdmin平添存储过程

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


phpMyAdmin平添存储过程

?