µ¥ÀÌÅÍ ¼öÁý db ±¸ÃàÁß ±¸ÇöÁß¿¡ À߾ȵǼ Áú¹® µå¸³´Ï´Ù..
tableÀÌ ¾Æ·¡¿Í °°ÀÌ 2°³°¡ Àִµ¥,
table 1 [idx / pk code / pcode / icode / datetime / data 1 / data 2 / .. data 5]
-- data1 [1, B10000, C0001, D0001, datetime, d0, d1, d2, d3, null] data 4°³
-- data2 [2, B10000, C0002, D0002, datetime, d4, d5, d6, null , null] data 3°³
-- data3 [3, B10000, C0003, D0003, datetime, d7, d8, null, null ,null] data 2°³
-- data4 [3, B10001, C0004, D0004, datetime, d7, d8, null, null, null] data 2°³
-- data5 [1, B10001, C0001, D0001, datetime, d0, d1, d2, d3, null] data 4°³
-- data6 [2, B10001, C0002, D0002, datetime, d4, d5, d6, null, null] data 3°³
-- data7 [3, B10001, C0003, D0003, datetime, d7, d8, null, null, null] data 2°³
-- data8 [3, B10001, C0004, D0004, datetime, d7, d8, null, null, null] data 1°³
table 2 [idx / fk code / .. .. .. ..]
-- data1 [1, B10000 ...]
-- data2 [2, B10001 ...]
-- data3 [3, B10002 ...]
table 1ÀÇ µ¥ÀÌÅ͸¦ °¡°øÇÏ¿©, pk code·Î ¹¾î¼ 1°³ÀÇ µ¥ÀÌÅÍ·Î ¸¸µé°í ½Í½À´Ï´Ù.
pcode ¸¶´Ù µ¥ÀÌÅÍ ÀúÀåµÇ´Â °¹¼ö´Â ´Ù¸¨´Ï´Ù. (4°³ , 3°³ , 2°³ ¶ó°í °¡Á¤)
¿¹¸¦ µé¾î µ¥ÀÌÅÍ°¡ ÇÕÃÄÁö¸é
-- data [B10000, D0001, d0, d1, d2, d3, D0002, d4, d5, d6, C0003, d7, d8 , C0004, d7, d8]
-- data [B10001, D0001, d0, d1, d2, d3, D0002, d4, d5, d6, C0003, d7, d8 , C0004, d7, d8]
ÀÌ·±½ÄÀ¸·Î ¸¸µé°í ½ÍÀºµ¥ ¹æ¹ýÀÌ ¾øÀ»±î¿ä?
¾Æ´Ï¸é ´Ù¸¥ ¹æ½ÄÀ¸·Ð
1) À§¿Í °°ÀÌ µ¥ÀÌÅ͸¦ °¡°øÇÏ¿© °Ë»ö°ü¸®
2) Àüü data°¡ µé¾î°¥ Å×À̺íÀ» 1°³¸¦ Ãß°¡·Î ¸¸µé¾î¼ µ¥ÀÌÅÍ »ðÀԽà ¸¶´Ù updateÇÏ¿© Ãß°¡ÇÏ¸ç °Ë»ö°ü¸®
-> ÀÌ·¸°Ô µÇ¸é Ä÷³¼ö¸¸ 200°³ ÀÌ»óÀ̵Ǽ °í¹ÎÁßÀÔ´Ï´Ù.
|
select distinct * from talbe1
Áߺ¹µ¥ÀÌÅ͸¦ ã´Â°Ô ¾Æ´Ï¶ó, Á¶È¸½Ã ³ª¿À´Â µ¥ÀÌÅ͵éÀ» ÇÕÄ¡°í ½Í¾î¼ ±×·¯´Âµ¥ À߾ȵǼ¿ä.
µ¥ÀÌÅÍ´Â pcode·Î ±¸ºÐÈÄ µ¥ÀÌÅÍ ¿µ¿ª¸¸ ÃßÃâÇؼ ÇÕÄ¡·Á´Âµ¥ Àß ¾ÈµÇ¼¿ä
query : select * from table1 where pk code = 'B1000'
result :
-- data1 [1, B10000, C0001, D0001, datetime, d0, d1, d2, d3, null] »ç¿ë µ¥ÀÌÅÍ data 4°³ (d0 ~d3)
-- data2 [2, B10000, C0002, D0002, datetime, d4, d5, d6, null , null] »ç¿ë µ¥ÀÌÅÍ data 3°³ (d4 ~d6)
-- data3 [3, B10000, C0003, D0003, datetime, d7, d8, null, null ,null] »ç¿ë µ¥ÀÌÅÍ 2°³ (d7 ~d8)
°¡°øÈÄ
data [B10000, D0001, d0, d1, d2, d3, D0002, d4, d5, d6, C0003, d7, d8 , C0004, d7, d8]
data [B10001, D0001, d0, d1, d2, d3, D0002, d4, d5, d6, C0003, d7, d8 , C0004, d7, d8]
data [B10003, D0001, d0, d1, d2, d3, D0002, d4, d5, d6, C0003, d7, d8 , C0004, d7, d8]
....
....
ÀÌ·±½ÄÀ¸·Î ...