这段到底什么错呢？该怎么解决

这段到底什么错呢？

SQL code

 create procedure sp_cube_inverter_d (in p_nowdate datetime) begin   declare v_nowdate    char(8);   declare v_curdate    datetime;    set v_curdate = left(p_nowdate,10);   set v_nowdate = replace(cast(v_curdate as char(10)),'-',''); 

欢迎大家阅读《这段到底什么错呢？该怎么解决》,跪求各位点评，by 搞代码

>［错误］ 脚本行：1-90 ————————————–
 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 ‘procedure sp_cube_inverter_d ( in p_nowdate datetime)
begin
  declare v_nowdate ‘ at line 45 

 警告：—> 
  W (1): 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 ‘procedure sp_cube_inverter_d ( in p_nowdate datetime)
begin
  declare v_nowdate ‘ at line 45

——解决方案——————–
应该不是空格的原因吧，下面测试没有任何问题啊。

SQL code

 mysql> delimiter // mysql> create procedure sp_cube_inverter_d (in p_nowdate datetime)     -> begin     ->   declare v_nowdate    char(8);     ->   declare v_curdate    datetime;     ->     ->   set v_curdate = left(p_nowdate,10);     ->   set v_nowdate = replace(cast(v_curdate as char(10)),'-','');     -> end // Query OK, 0 rows affected (0.26 sec)  mysql> delimiter ; mysql> 
------解决方案--------------------


探讨
( in p_nowdate datetime )
加个空格就好了，晕。
mysql语法太敏感了

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权 
转载请注明原文链接：这段到底什么错呢？该怎么解决 
  
 喜欢 (0)赏
[搞代码]
分享 (0)