|
报错现象:
我这个解决办法就是 把 begin以上都删掉 可以保存成功 , 但是因为无法设置utf-8 导致存入时报1366错误
验证:
mysql> use oa;
Database changed
mysql> show create procedure sex;
+-----------+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation |
+-----------+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| sex | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`%` PROCEDURE `sex`()
begin
DECLARE SEX bit ;
IF stusex='1' then
set sex ='1';
END IF ;
IF stusex='0' THEN
SET SEX ='2';
end IF ;
END | utf8mb4 | utf8mb4_0900_ai_ci | utf8_bin |
+-----------+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)
mysql>
|
|