http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (Developer) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (Developer)
Stored procedure Àε¥ ¹Ýº¹È£Ãâ½Ã ¸ØÃß´Â Çö»óÀÌ °¡²û ¹ß»ýÇÕ´Ï´Ù.
±Û¾´ÀÌ : doraq   ³¯Â¥ : 15-08-25 10:05   Á¶È¸¼ö : 4656
DROP PROCEDURE IF EXISTS tivo_hybrid.register_end;
CREATE PROCEDURE tivo_hybrid.`register_end`(
 IN  i_serial VARCHAR(100),
 OUT o_result VARCHAR(50)
)
BEGIN  
 DECLARE dbErr INT DEFAULT 0;
 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET dbErr = -1;
 SET @q_serial = i_serial;
        SET @q_result = 'OK';
 IF (@q_serial IS NULL OR @q_serial = '') THEN
  SET @q_result = 'ERR: NULL argument';
 ELSE
  UPDATE tivo_serial_master SET end_fg = 'OK' WHERE serial = @q_serial;
  IF dbErr < 0 THEN
   SET @q_result = 'ERR: update end_fg';
  ELSE
                        SET @q_result = 'OK';
  END IF;
 END IF;
  SET o_result = @q_result;
  SELECT o_result;
END;

´Ü¼øÇÕ´Ï´Ù. º°°Å ¾ø¾î¿ä.
PCÂÊ¿¡¼­ ¸¶Áö¸·À¸·Î "´Ù Àß Çß´Ù". ¶ó°í  ½á³Ö´Â°Çµ¥ PC¿¡¼­
SQLDirectExecute ·Î À̰ÍÀ» È£ÃâÇßÀ»¶§ ¸ØÃä´Ï´Ù. ÀÌ ÇÔ¼ö¿¡¼­ ³ª¿ÀÁö¸¦ ¾Ê¾Æ¿ä.
Timeoutµµ ¼³Á¤µÇÀִµ¥ ¸®ÅÏ ÀÚü¸¦ ¾ÈÇÕ´Ï´Ù.
¹ß»ýºóµµ´Â Á» ·»´ýÀε¥, 300¹øÂëÀ϶§µµ ÀÖ°í, 8000¹ø ÂëÀ϶§µµ ÀÖ¾î¿ä.
¾Æ¹«¸®ºÁµµ À̰Թ®Á¦´Â ¾Æ´Ñ°Å °°Àºµ¥ PCÂʵµ ³ª¸§ ¿À·¡ ½á¿À´ø ÄÚµå¶ó³×¿ä.
Á¶±Ý¸¸ ºÁÁÖ¼¼¿ä..
Âü, ¸¶Áö¸· SELECT´Â @o_result·Îµµ ÇØºÃ¾î¿ä. ¸¶Âù°¡Áö¿¹¿ä.
ÀÌÀü±Û MySQL ÀúÀ۱ǿ¡ ´ëÇÑ Áú¹®À» µå¸®¿À´Ï È®½ÇÇÑ ´äº¯ ºÎʵ右´Ï´Ù. 
´ÙÀ½±Û µ¿½Ã°£ ¾÷µ¥ÀÌÆ® ¹æÁö ¾î¶»°Ô ÇØ¾ß ÇÒ±î¿ä? 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.