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的语法不是这样。

喜欢 (0)赏

[搞代码]

分享 (0)