dedecms5.7入库存储过程，错误码: 1307 Failed to CREATE PROCEDURE mysql创建存储过
本帖最后由 ceodiy 于 2012-3-14 15:04 编辑哪位大侠了解mysql，给试试怎么回事，错误码: 1307 Failed to CREATE PROCEDURE mysql创建存储过程失败
DELIMITER $$
CREATE
/**/
PROCEDURE `dedecmsv57gbksp1`.`insertww`(
qtypeid INT,
qchannel INT,
qtitle VARCHAR(255),
qfahuo VARCHAR(250),
qlocation VARCHAR(250),
qkeyword VARCHAR(250),
qtableinfo MEDIUMTEXT,
qinfo MEDIUMTEXT,
qcontact MEDIUMTEXT
)
BEGIN
DECLARE idid INT;
INSERT INTO dede_arctiny (typeid,channel,MID) VALUES ( qtypeid, qchannel, '1');
IF ( ROW_COUNT() > 0 )
THEN
SELECT LAST_INSERT_ID() INTO idid;
ELSE
ROLLBACK;
END IF;
INSERT INTO dede_zgy (aid,typeid,channel,MID,title,litpic,fahuo,location,keyword,tableinfo,info,contact) VALUES(idid,qtypeid,qchannel,'1',qtitle,'',qfahuo,qlocation,qkeyword,qtableinfo,qinfo,qcontact);
IF ( ROW_COUNT() > 0 )
THEN
COMMIT;
ELSE
ROLLBACK;
END IF;
END$$
DELIMITER ;
页:
[1]