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)),'-','');
>[错误] 脚本行: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
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)),'-','');
>[错误] 脚本行: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
解决方案 »
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, ?
- mysql slow-log大文件切分问题
- 请教unix+mysql中的mysql写文件权限问题
- 时间平均化的问题
- mysql 如何只优化一个分区?
- 求 gostgreSQL 的 链接库文件
- mysql储存量的问题
- 创建不了数据库,出现以下问题,我也知道是权限的问题,但是解决不了?
- 为啥查询速度有时快有时慢?
- 如何禁止自动提交?(是不是mysql中的自动提交被它的驱动屏蔽了,为什么有这this.con.setAutoCommit(false);也不行。)
- mysql看看我这个存储过程,为什么运行之后多了条数据。
- 请问INSERT VALUES(),(),() 和分开写的INSERT VALUES();哪种效率更高?
加个空格就好了,晕。mysql语法太敏感了
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>
哎,不纠结了,结账吧