mysql add列 报错1064_mysql 总报错 Error Code : 1064 请

mysql 总报错 Error Code : 1064 请高手指点

我是个新手 找了一下午错误了 头大了 请高手指点 到底是哪里错了。。

DELIMITER $$

CREATE PROCEDURE `pr_addshieldstateparam`(

IN mobile VARCHAR(60),

IN sendNo VARCHAR(60),

IN reason VARCHAR(200),

IN jobNumber VARCHAR(60))

BEGIN

DECLARE resultCode VARCHAR(2);

-- DECLARE resultDesc VARCHAR(500);

SET autocommit = 0;

IF sendNo IS NULL THEN

SET sendNo='';

END IF;

IF reason IS NULL THEN

SET reason='';

END IF;

IF sendNo='' THEN

SELECT -1 AS resultCode;

ELSEIF

INSERT INTO shieldstate(mobile,sendno,reason,jobnumber)

VALUES (mobile,sendNo,reason,jobNumber);

INSERT INTO shieldstate_log(mobile,sendno,reason,jobnumber,operation)

VALUES (mobile,sendNo,reason,jobNumber,'0');

IF @@warning_count <> 0 ||@@error_count>0

THEN

ROLLBACK;

SELECT -2 AS resultCode;

ELSE

COMMIT;

SELECT 0 AS resultCode;

END IF;

END IF;

END$$

DELIMITER ;

报错信息：

Query : CREATE PROCEDURE `pr_addshieldstateparam`( IN mobile varchar(60), in sendNo varchar(60), in reason varchar(200), in jobNumber v...

Error Code : 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 'into shieldstate(mobile,sendno,reason,jobnumber)

values (mobile,sendNo,reason,' at line 19

------解决方案--------------------

DELIMITER $$

CREATE PROCEDURE `pr_addshieldstateparam`(

IN mobile VARCHAR(60),

IN sendNo VARCHAR(60),

IN reason VARCHAR(200),

IN jobNumber VARCHAR(60))

BEGIN

DECLARE resultCode VARCHAR(2);

-- DECLARE resultDesc VARCHAR(500);

SET autocommit = 0;

IF sendNo IS NULL THEN

SET sendNo='';

END IF;

IF reason IS NULL THEN

SET reason='';

END IF;

IF sendNo='' THEN

SET resultCode=-1 ;

ELSE

INSERT INTO shieldstate(mobile,sendno,reason,jobnumber)

VALUES (mobile,sendNo,reason,jobNumber);

INSERT INTO shieldstate_log(mobile,sendno,reason,jobnumber,operation)

VALUES (mobile,sendNo,reason,jobNumber,'0');

END IF;

IF @@warning_count <> 0 AND @@error_count>0 THEN

ROLLBACK;

SELECT -2 AS resultCode;

ELSE

COMMIT;

SELECT 0 AS resultCode;

END IF;

-- END IF;

END$$

DELIMITER ;

------解决方案--------------------

逻辑判断自行检查一下

------解决方案--------------------

IF @@warning_count <> 0 or @@error_count>0

------解决方案--------------------

IF sendNo='' THEN

SELECT -1 AS resultCode;

ELSE

INSERT INTO shieldstate(mobile,sendno,reason,jobnumber)

VALUES (mobile,sendNo,reason,jobNumber);

INSERT INTO shieldstate_log(mobile,sendno,reason,jobnumber,operation)

VALUES (mobile,sendNo,reason,jobNumber,'0');

ELSEIF的语法不是这样。

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~