ͻ񻣼
1.listagg() WITHIN GROUP () ½«¶àÐкϲ¢³ÉÒ»ÐÐ select ÁÐÃû1,listagg (ÁÐÃû, ',') WITHIN GROUP (ORDER BY ÁÐÃû) OVER(partition by ÁÐÃû1) as ±ðÃû from ±íÃû where Ìõ¼þ±í´ïʽ; ²Î¿¼×ÊÁÏ£ºht ÔĶÁÈ«ÎÄ
ͻ񻣼
Windows OS Linux OS ͬÀí£¬impÒ²ÊÇÒ»Ñù¡£ ÔĶÁÈ«ÎÄ
ͻ񻣼
Ä¿µÄ£ºÓÉÓÚ¹«Ë¾Êý¾Ý¿âȨÏÞ¹ÜÀíµÄºÜÑÏ£¬Ã¿´Îн¨±íºóÐèÒªÊÖ¶¯ÊÚȨ¸øÏàÓ¦µÄÓû§£¬²¢ÇÒ»¹Òª´´½¨Í¬Òå´Ê¡£Õâ¾ÍºÜÊÇÂé·³¡£Õ˺ÅÒ»¶à¾ÍÌرð»¨Ê±¼ä¡£a56爆大奖在线娱乐×Ô¼ºÐ´ÁËÁ½¸ö´æ´¢¹ý³ÌºÍ¶¨Ê±JOBÀ´ÊµÏÖ¶¯Ì¬ÊÚȨ¡£ ÐèÇó£ºAÓû§·ÃÎÊBÓû§£¬AÓû§¿ÉÒÔÔöɾ¸Ä²éBÓû§ËùÓÐ±í£¨²»°üÀ¨ÏµÍ³±í£©¡£AÊÇÆÕͨÓû§£¬BÓû§ÓµÓÐDBAȨÏÞ£¬a56爆大奖在线娱乐a56爆大奖在线娱乐ÃÇ ÔĶÁÈ«ÎÄ
ͻ񻣼
×¼±¸¹¤×÷ ÏÂÔØmysql¶þ½øÖÆ°ü£¬ÒÔ¼°°²×°mysqlÒÀÀµ°ü #°²×°mysqlËùÐèÒÀÀµ°ü yum install libaio* -y #ÏÂÔØmysql¶þ½øÖÆ°²×°°ü wget http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.14-l ÔĶÁÈ«ÎÄ
ͻ񻣼
ÓÉÓÚÏÖÓзÓÉÆ÷²»Ö§³ÖSNMPÐÒ飬a56爆大奖在线娱乐ÎÞ·¨Ö±½Ó¼à¿ØÍøÂçÁ÷Á¿£»²¢ÇÒZabbix×Ô¶¯·¢ÏÖÍøÂç²»·ûºÏa56爆大奖在线娱乐ÒªÇó£¬a56爆大奖在线娱乐×Ô¼ºÊÖ¶¯ÅäÖÃÁËÏ 1.»ñÈ¡Íø¿¨ÐÅÏ¢£¬ÕâÀïÓиöÂé·³ÊÂÇé¾ÍÊÇ£¬Èç¹ûÓжà¿éÍø¿¨ÐèÕÒµ½ÕýÔÚʹÓõÄÍø¿¨£¬»òÕß½«ËùÓÐÍø¿¨¶¼Ìí¼Ó½øÀ´Ò²¿ÉÒÔ£» 2.ÐÞ¸Äzabbix_agentd.win.confÅäÖÃÎļþ£¬ÔÚÄ© ÔĶÁÈ«ÎÄ
ͻ񻣼
ZABBIX-JAVA-GATEWAY ¹¤×÷ÔÀí ²¿Êð ZABBIX-JAVA-GATEWAY£¬ÓÉÓÚËùÓð汾Ϊ3.4.12£¬¸Ã°æ±¾×Ô´øZABBIX-JAVA-GATEWAY²å¼þ£¬a56爆大奖在线娱乐a56爆大奖在线娱乐ÃǺöÂÔ°²×°²¿·Ö¡£Ö±½Ó½øÈëÅäÖý׶ΠÐÞ¸Ä/usr/local/zabbix-3.4.12/sbin/zabbix_ja ÔĶÁÈ«ÎÄ
ͻ񻣼
Ò»¡¢°²×°RabbitMQ °²×°rabbitmqËùÐèµÄerlangÈí¼þ°ü£¬·½·¨Óжþ£¨±àÒëºÍyum°²×°£©£¬ÕâÀï²ÉÓÃyum°²×° °²×°erlang/socat °²×°rabbitmq ´´½¨rabbitmqÓû§ ÅäÖÃÔ¶³Ì·ÃÎÊ Ä£¿é¿ª·Å ²é¿´ÒÑ¿ª·ÅµÄÄ£¿é ·À»ðǽ¿ª·Å¶Ë¿Ú ¸½ÉÏrabbitmq³£ÓÃÃüÁî ¶þ¡¢ÅäÖÃsh ÔĶÁÈ«ÎÄ
ͻ񻣼
´íÎóÌáʾÈçÏ ½âÊÍÏÂÁ½¸ö²ÎÊý ¸Ã´íÎóÊÇÓÉÓÚ$releaseverºÍ$basearchÕâÁ½¸ö±äÁ¿ÖÐÈκa56爆大奖在线娱乐»¸öÎÞ·¨Ê¶±ð¶¼»á³öÏÖÉÏÃæµÄ´íÎó£¬a56爆大奖在线娱乐ÔÚÅäÖÃyumÔ´µÄʱºòÊ×ÏÈҪȷÈÏÕâÁ½¸ö±äÁ¿ÊÇ·ñ´æÔÚ¡£ Èç¹û±äÁ¿²»´æÔÚ¾ÍÓÃÊý×Ö6ºÍi386/x86_64´úÌæ¡£ a56爆大奖在线娱乐µÄÅäÖÃÈçÏ ²Î¿¼²©¿Í ÔĶÁÈ«ÎÄ
ͻ񻣼
»·¾³£ºCentos 6.5 64 Ä¿µÄ£ºÎÞͼÐνçÃæ°²×°OracleÊý¾Ý¿â °æ±¾£º11g 64 Ò»¡¢ÏµÍ³ÅäÖà 1.°²×°Ïà¹ØÒÀÀµ°ü£¬¿Éͨ¹ý¹ÒÔؾµÏñ»òÕß°¢ÀïÔÆ¡¢ÍøÒ×ÔƵȿªÔ´¾µÏñÕ¾ yum install binutils -y yum install compat-libcap1 -y yum insta ÔĶÁÈ«ÎÄ
ͻ񻣼
1.´´½¨mysqlÓû§×éºÍÓû§ groupadd mysql useradd -r -g mysql -s /sbin/nolog mysql 2.ÏÂÔØmysqlÏà¹Ø°æ±¾¶þ½øÖÆ°ü£¬²¢½âѹÒƶ¯ÖÁ/usr/localĿ¼ wget http://mirrors.163.com/mysql/Downloa ÔĶÁÈ«ÎÄ