469845f54897c2fd73.png (21.87 KB, 下载次数: 281)
2020-9-6 15:02 上传
我这个解决办法就是 把 begin以上都删掉 可以保存成功 ， 但是因为无法设置utf-8 导致存入时报1366错误
351545f5489de25530.png (21.25 KB, 下载次数: 286)
2020-9-6 15:03 上传
验证：
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>
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |