MYSQL Áú¹®

   Á¶È¸ 7631   Ãßõ 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 4030/5686
2014-05   4978085   Á¤ÀºÁØ1
2015-12   1514226   ¹é¸Þ°¡
2015-02   9241   GodokNam
2017-06   5344   ÇÑÈ¿¼®
2017-06   4160   NAS°íÀå³µ´Ù¡¦
2017-07   3228   ±â¹¦ÇÑ»ýÈ°
2020-04   4806   ÄĹÚ
2020-05   2940   B4TT3RY
2022-01   1503   ±è¿µ±â
2017-02   5271   Sikieiki
2015-01   13404   KunSergio77
2022-08   1740   ¾¾¿£
2017-06   2862   Cobb
2017-07   4270   ³ªÆÄÀÌ°­½ÂÈÆ
2017-07   3290   ÁÖ¿µÁø¿µ¾Æºü
2017-08   3270   µÎcpu
2021-06   4030   Tails
2016-09   3895   ¹Ì¼ö¸Ç
2016-09   4991   ±èȲÁß
2014-11   10775   ºü½Ã¿Â
2022-01   1277   ±èÈ¿¼ö
2017-03   14672   s±èÁ¾È­z