你的位置:

問答吧

-> MySQL

-> 問題詳情

mysql的存儲怎么寫？幫我看看我這個寫的哪里有問題？謝謝

DELIMITER $$;

DROP PROCEDURE IF EXISTS `ebill`.`SP_GETSEQNO`$$

CREATE DEFINER=`AUTEK`@`%` PROCEDURE `SP_GETSEQNO`(storSEQNAME VARCHAR(32),

storWORKDATE VARCHAR(10),

OUT storSEQNO INT )

BEGIN

DECLARE storCLTID INT;

IF storWORKDATE='' THEN

SELECT storCLTID = CLTID,storSEQNO = SEQNO FROM CLT_SEQ WHERE SEQNAME=storSEQNAME;

ELSE

SELECT storCLTID = CLTID,storSEQNO = SEQNO FROM CLT_SEQ WHERE SEQNAME=storSEQNAME AND WORKDATE=storWORKDATE;

END IF;

IF row_count() = 0 THEN

INSERT INTO CLT_SEQ(SEQNAME,WORKDATE,SEQNO) VALUES(storSEQNAME,storWORKDATE,1);

SET storSEQNO = 1;

ELSE

UPDATE CLT_SEQ SET SEQNO=storSEQNO+1 WHERE CLTID=storCLTID;

SET storSEQNO = storSEQNO+1;

END IF;

END$$

DELIMITER ;$$

作者: gaochaohaha

發布時間: 2011-08-11

在線等 高手們幫我看看吧 萬分感謝~~~！！！

作者: gaochaohaha

發布時間: 2011-08-11

DELIMITER $$

DROP PROCEDURE IF EXISTS `SP_GETSEQNO`$$

CREATE PROCEDURE `SP_GETSEQNO`(storSEQNAME VARCHAR(32), storWORKDATE VARCHAR(10),

OUT storSEQNO INT )

BEGIN

DECLARE storCLTID INT;

IF storWORKDATE='' THEN

SELECT storCLTID = CLTID,storSEQNO = SEQNO FROM CLT_SEQ WHERE SEQNAME=storSEQNAME;

ELSE

SELECT storCLTID = CLTID,storSEQNO = SEQNO FROM CLT_SEQ WHERE SEQNAME=storSEQNAME AND WORKDATE=storWORKDATE;

END IF;

IF ROW_COUNT() = 0 THEN

INSERT INTO CLT_SEQ(SEQNAME,WORKDATE,SEQNO) VALUES(storSEQNAME,storWORKDATE,1);

SET storSEQNO = 1;

ELSE

UPDATE CLT_SEQ SET SEQNO=storSEQNO+1 WHERE CLTID=storCLTID;

SET storSEQNO = storSEQNO+1;

END IF;

END$$

DELIMITER ;

作者: wwwwb

發布時間: 2011-08-11

總結

以上是生活随笔為你收集整理的mysql get seq no_mysql的存储怎么写？帮我看看我这个写的哪里有问题？谢谢的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。