MYSQL Áú¹®

   Á¶È¸ 7653   Ãßõ 0    

a,b,c,d,e,f ¶ó´Â 6°³ÀÇ Å×À̺íÀÌ ÀÖ°í a,b,c,d,e¸¦ f¶ó´Â Å×ÀÌºí¿¡ ³Ö°í½Í½À´Ï´Ù.

union...join µîµî ã¾Æº¸´Ï ¸¹´øµ¥ ÀÌ·±°Ç Çغ»Àûµµ ¾ø´ÂÁö¶ó...¹®ÀÇÁ» µå¸³´Ï´Ù.

°¢ Å×ÀÌºí¸¶´Ù ÇÊµå µ¿ÀÏÇÏ°í Áߺ¹µÇ´Â °ªÀº ¾ø½À´Ï´Ù.



insert into Å×À̺íf SELECT * FROM Å×À̺ía Çϸé Àßµé¾î°¡´Âµ¥ 5°³ ÇѰŹø¿¡´Â ¾îÂî ³Ö¾î¾ßÇÏ´ÂÁö...
서버 모니터링, 라즈베리파이에 관심이 많습니다.
http://www.sproc.co.kr
http://rpi.sproc.co.kr
http://noaa.sproc.co.kr
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.
Á¶¿µ¹Î 2010-02
oracleÀÇ °æ¿ì¶ó mysql¿¡¼­ ¾î¶»°Ô Àû¿ëµÉÁö´Â ¸ð¸£°Ú½À´Ï´Ù¸¸....

insert into AAA
(
select *
from BBB
union all
select *
from CCC
)
insert into f ( select * from (select * from a union select * from b union select * from c union select * from d union select * from e) g);  ÀÌ°Ô ¸ÂÀ»²¨¶ø´Ï´Ù. ÇãÇãÇã
¸ù¸ù 2010-02
scheme °¡ µ¿ÀÏÇÏ°í Áߺ¹µÈ row °ªÀÌ ¾ø´Â Å×À̺íµéÀÇ º´ÇÕÀ̶ó¸é

insert into f (select * from a union select * from b ... union select * from e)

·Î ÇÏ¸é µÇ°Ú³×¿ä
insert into f
(Ä÷³1, Ä÷³2, Ä÷³3, ''''''''')

select Ä÷³1, Ä÷³2, Ä÷³3, ''''''''' from a
union all
select Ä÷³1, Ä÷³2, Ä÷³3, ''''''''' from b
union all
select Ä÷³1, Ä÷³2, Ä÷³3, ''''''''' from c
union all
select Ä÷³1, Ä÷³2, Ä÷³3, ''''''''' from d
union all
select Ä÷³1, Ä÷³2, Ä÷³3, ''''''''' from e
±Ç±âÁØ 2010-02
µ¥ÀÌŸÀÇ ·®ÀÌ ¸¹À» °æ¿ì¿£ union Àº ±ÇÀåÇÏÁö ¾Ê´Â´Ù°í Åë»ó À̾߱âÇÕ´Ï´Ù.
union ¿¬»êÀÚ¸¦ »ç¿ëÇϸé sql ÀÇ ¼º´ÉÀÌ ´ç¿¬È÷ ¾öû³ª°Ô ´À·ÁÁö°í ¼­¹öÀÇ ÀÚ¿øµµ ±×¸¸Å­ ¸¹ÀÌ ¼Ò¸ðµÇ¾î Àüü DB ¼º´Éµµ ´À·ÁÁ®¼­ ¹Ù¶÷Á÷ÇÏÁö ¾Ê´Â °æ¿ì¸¦ ¸¸µé ¼ö ÀÖ½À´Ï´Ù. 
±×³É ½ºÅ©¸³Æ® Çϳª ¸¸µé¾î¼­ batch ·Î °¢ insert ¹®À» Â÷·Ê´ë·Î ½ÇÇà½ÃÅ°´Â °ÍÀÌ ÈξÀ ºü¸¦ ²®´Ï´Ù.
Á˼ÛÇÕ´Ï´Ù. ´Ù µå¸®°í ½ÍÀºµ¥ ÇѸí¹Û¿£ ¾ÈµÇ´Â°Å±º¿ä...


QnA
Á¦¸ñPage 1214/5691
2014-05   5016413   Á¤ÀºÁØ1
2015-12   1551878   ¹é¸Þ°¡
2016-09   7659   ±è°Ç¿ì
2011-04   7658   ±èÀå¿ì
2011-02   7658   º¸¹°¼¶
2004-04   7658   ÇöÁø
2004-04   7658   À̽ÂÇö
2019-08   7658   È£¹Ú°í±¸¸¶
2010-10   7658   ³²¼º·æ
2004-07   7658   ¹ÚÂù¹Î
2019-05   7657   ½Ãµµ´Ï
2014-02   7657   ¼Õ°©ºó
2010-11   7657   °ÌÀïÀÌ¿ì¼Ù
2006-04   7657   ±èÅÂÈÆ
2017-10   7657   AplPEC
2010-03   7657   ±èÁÖ¿ës
2011-02   7657   ¼Û¼®±Ù
2017-07   7656   ¼º¹Î
2018-03   7656   Æ丣¼¼¿ì½º
2004-08   7656   ÀÓ½ÃÇö
2004-11   7656   µµÇö¼ö
2016-07   7656   SpringValley