Q&A
  • DB Q&A
Á¦½Ç·ÂÀ¸·Ð ¾ÈµÇ°Ú½À´Ï´Ù µµ¿ÍÁÖ¼¼¿ä
±Û¾´ÀÌ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ÉÀ½¸¶ºÎÅÍ ³¯ Â¥ 12-03-27 10:02 Á¶ ȸ 483
°£ÆíURL http://phpschool.com/link/qna_db/186187 º¹»ç

SyntaxHighlight·Î º¸±â

´äº¯Ã¤ÅÃÀ² 100 %
ÇлýÅ×À̺í
id  |  name
1  | ±è±¹Áø
3  | È«±æµ¿
=============
Å»ÅðÅ×À̺í
id  |  name
2  | ¸¶·çÄ¡
=============
ÀÏÁöÅ×À̺í
id 
1
2
3
=============


SELECT A.ID,(SELECT NAME FROM ÇлýÅ×À̺í WHERE ID = A.ID) AS NAME
FROM ÀÏÁöÅ×À̺í A
ORDER BY NAME

ÀÏÁöÅ×ÀÌºí¿£ 2¹ø ¸¶·çÄ¡°¡ ±â·ÏÀÌ µÇÀִµ¥ ÇлýÅ×ÀÌºí¿¡ ¾øÀ¸´Ï Á¶È¸°¡ ¾ÈµË´Ï´Ù.
±×·¡¼­ ¾øÀ¸¸é Å»ÅðÅ×ÀÌºí¿¡¼­ Á¶È¸¸¦ ÇØ¿À°í ½ÍÀºµ¥ °¡´ÉÇѰ¡¿ä??
mysql ¾¹´Ï´Ù.

id  |  name
1  | ±è±¹Áø
2  | ¸¶·çÄ¡
3  | È«±æµ¿

Àüü´ñ±Û¼ö 7

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§±×³× 12-03-27 10:16

    ¼Ò½ºº¸±â

  • ÀÏÁö Å×ÀÌºí¿¡ id ¿¡ ´ëÇØ¼­ ÇлýÅ×À̺í°ÍÀÎÁö Å»ÅðÅ×ÀÌºí °ÍÀÎÁö¸¦ ±¸ºÐÇÒ ¼ö ÀÖ´Â ±¸ºÐÀÚ°¡ ÀÖÀ½ ÁÁ°ÚÁö¿ä.

    ¶Ç ´Ù¸¥ ¹æ¹ýÀ¸·Î´Â
    ±×³É ¾îÂ÷ÇÇ À̸§¸¸ °¡Á®¿À¸é µÇ´Â°Å´Ï±ñ Çлý°ú Å»Å𸦠union ÇÏ¸é µÇ°ÚÁö¿ä
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ÉÀ½¸¶ºÎÅÍ 12-03-27 10:39

    ¼Ò½ºº¸±â

  • ÀÏÁö Á¶È¸½Ã Çлý À̸§ÀÌ ¾È³ª¿Í¼­ Çлý »èÁ¦¸¦ ÇÏ´Ï ±×·¸´õ¶ó±¸¿ä
    ±×·¡¼­ ±ÞÈ÷ ¼öÁ¤ÇÑ°Ô Çлý»èÁ¦½Ã Å»ÅðÅ×À̺í·Î Àμ­Æ®ÈÄ »èÁ¦ÇÏ°Ô Ã³¸®¸¦ Çß½À´Ï´Ù.
    Å×ÀÌºí ¼³°è ¾ÆÁÖ Á×°Ú½À´Ï´Ù Ãʺ¸ÇÑÅ×´Â...
    À¯´Ï¿ÂÀ» ¾ÆÁ÷ ¾È½áºÁ¼­ ÀÌÂü¿¡ °øºÎÁ» ÇØºÁ¾ß°Ú½À´Ï´Ù.
    ´ä±Û °¨»çÇÕ´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ºÒÄ£ÀýÇÑÇÏǰ 12-03-27 10:19

    ¼Ò½ºº¸±â

  • °á°ú´Â ³ª¿À°ÚÁö¸¸.. ÁÁÀº Äõ¸®ÀÎÁö´Â ¸ð¸£°Ú³×¿ä..
    Âü°íÇϼ¼¿ä.
    select A.id, (select name from (select * from ÇлýÅ×À̺í union all select * from Å»ÅðÅ×À̺í order by name) B where id=A.id) name from ÀÏÁöÅ×À̺í A
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ÉÀ½¸¶ºÎÅÍ 12-03-27 10:40

    ¼Ò½ºº¸±â

  • Å×½ºÆ®Çغ»°á°ú Àß³ª¿É´Ï´Ù..¼Óµµµµ ºü¸£³×¿ä...¾ÆÁ÷ ·¹ÄÚµå¼ö°¡ Àû¾î¼­ ±×·±°¡º¾´Ï´Ù.
    À¯´Ï¿Â¿Ã ½áºÁ¾ßÁö½áºÁ¾ßÁö Çß¾ú´Âµ¥ ÀÌÂü¿¡ °øºÎÁ» µÇ¾ú³×¿ä.
    ´ä±Û °¨»çÇÕ´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾ËÂùµ¹ÀÌ 12-03-27 10:21

    ¼Ò½ºº¸±â

  • select a.id, if(b.id is not null,b.name,c.name) from ÀÏÁöÅ×À̺í a left join ÇлýÅ×À̺í b on a.id=b.id left join Å»ÅðÅ×À̺í c on a.id=c.id
    left join¸¸À¸·Îµµ °¡´ÉÇÒµí
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ÉÀ½¸¶ºÎÅÍ 12-03-27 10:42

    ¼Ò½ºº¸±â

  • ÀÌÇÁ¹® »ý°¢Àº Çߴµ¥ Á¶Àι®À» ¹ÌÃÄ »ý°¢ ¸øÇß½À´Ï´Ù.
    À¯´Ï¿ÂÀº ¾È½áº¸°í ¼­ºêÄõ¸® Á¶Àι® ¸¸ ÁÖ±¸Àåâ ½á¿Ô´Âµ¥ ¹ÌÃÄ»ý°¢À» ¸øÇ߳׿ä.
    µµ¿ò ¸¹ÀÌ µÆ½À´Ï´Ù.
    Å×½ºÆ®Çغ»°á°ú À§¿¡ À¯´Ï¿Â¿ÃÀÌ ¼Óµµ°¡ Á» »¡¶ó¼­ À§¿¡Äõ¸®¸¦ ¾µ·Á°í¿ä..
    ´ä±Û °¨»çÇÕ´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§È«¾Æ¸§¢â 12-03-28 10:50

    ¼Ò½ºº¸±â

  • ÀÏÁöÅ×À̺íÀÌ ±âÁØÁ¡ÀÌ µÇ³Ä ¸¶³Ä¿¡ µû¶ó ½ºÄ®¶ó¼·Äõ¸®·Î ó¸®ÇÒ°ÍÀÎÁö, union À¸·Î ó¸®ÇÒ°ÍÀÎÁöÀÇ ºÐ±âÁ¡ÀÌ µÉ°Í °°½À´Ï´Ù¸¸.
  • °Ô½Ã¹° 72,438°Ç RSS
¹øÈ£´äº¯Á¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
°øÁö - [Çʵ¶»çÇ×]Q&A °Ô½ÃÆÇ ±ÔÄ¢ [28] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ä¿ÇÇÇÑÀÜ 08-10-01 114314
72,438 ¹Ì´äº¯ INNODB ¿Ü·¡Å°(FK)¿¡ 0°ª ³Ö±â »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§À嵿°Ç¯ 13-06-20 7
72,437 ¹Ì´äº¯ myadmin ¿ÜºÎÁ¢¼ÓÇϱâÀ§Çؼ­´Â ±ÇÇÑÀ» ¾îµð¼­ ¼³Á¤Çϳª¿ä? »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§²¤µ¿º¡ 13-06-20 6
72,436 ´äº¯ÁøÇà mysql system error: 113¿¡ ´ëÇØ¼­... [1] »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ø¹«¿ø°øºÎ10³âÂ÷ 13-06-19 18
72,435 ¹Ì´äº¯ ÆäÀÌÁö¿¡ Ãâ·Â »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ãʺ¸ÀÌ 13-06-19 29
72,434 ¹Ì´äº¯ latin1 DB¿¡ utf8 ÆäÀÌÁö·Î Á¢±ÙÀÌ ¾ÈµË´Ï´Ù... »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¿øÁ¶µ¹¸ÍÀÌ 13-06-19 28
72,433 ´äº¯ÁøÇà mysql ¸Þ¸ð¸® »ç¿ë·® ¹®ÀÇ [1] »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§imshari 13-06-19 44
72,432 - °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [1] »õ±Û VANDyke 13-06-19 31
72,431 ´äº¯¿Ï·á Ä®·³¿¡¼­ ƯÁ¤ ¹®ÀÚ¿­À» ġȯ Çϴ´ë, ÀÌ°É Àüü db Å×ÀÌºí ¿¡¼­¡¦ [1] »õ±Û ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§´©¶õÁö¼¼ 13-06-19 30
72,430 ´äº¯ÁøÇà ¼Ò¼ÈÄ¿¸Ó½ºDB ¸¦ °¡Áö°í Àִµ¥¿ä..´Ù½Ã°¡µ¿ÇÏ¿©.. [3] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÄíÆùÁö 13-06-18 80
72,429 ´äº¯ÁøÇà ÇÑÂÊ Å×ÀÌºí °ªÀ» Á¶°Ç¿¡ µû¶ó ´Ù¸¥ ÇÑÂÊ Å×ÀÌºí¿¡ ÀÔ·ÂÇÒ·Á°í ¡¦ [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§TheLastLeaf 13-06-18 32
72,428 ´äº¯ÁøÇà mysql ½ºÅä¾îµå ÇÁ·Î½ÃÁ® Áú¹®Á» µå¸±°Ô¿ä. [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§LittleBomb 13-06-18 36
72,427 ¹Ì´äº¯ Ȥ½Ã mssql ¿¡¼­ ƯÁ¤ µ¥ÀÌÅÍ update µÉ¶§ ¾î¶² ÆäÀÌÁö¿¡¼­ ¿äû¡¦ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§bellstar 13-06-18 42
72,426 ¹Ì´äº¯ mysql ÄܼÖâ¿¡¼­ ÇѱÛÀÌ ±úÁö³×¿ä ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§À̵¿½Äµð½ºÅ© 13-06-18 48
72,425 ´äº¯ÁøÇà ' Ç¥½Ã ÀԷ½à \' ÀÌ·¸°Ô DB ÀÔ·Â µË´Ï´Ù. [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼­ÅÂÁö¾ä 13-06-18 52
72,424 ´äº¯¿Ï·á PHP + ORACLE ÀÌ¿ë½Ã ´ÙÁß select ¹®È°¿ëÇϱâ... [5] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§µµÄ¡¾Æºü 13-06-18 68
72,423 ´äº¯ÁøÇà µ¥ÀÌÅͺ£À̽º Á¤·Ä Áú¹®ÀÔ´Ï´Ù.^^ [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Èì¹Ù¹Ù 13-06-17 68
72,422 ´äº¯¿Ï·á °ÔÀÓ¼øÀ§ db Äõ¸® ¸¦ ¾î¶»°Ô Â¥¾ß ÇÒ±î¿ä?? [4] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§gstaroncom 13-06-17 82
72,421 ´äº¯ÁøÇà [MSSQL] ÃÖ´ë ¿­ °³¼ö(1024°³)¸¦ Ãʰú ÇÒ ¼ö ÀÖ³ª¿ä? [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§KINKONG 13-06-17 73
72,420 ´äº¯¿Ï·á PHP + Oracle Á¢¼Ó½Ã ´ÙÁßÀ¸·Î Çڵ鸵Çϱâ!! [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§µµÄ¡¾Æºü 13-06-17 55
72,419 ´äº¯¿Ï·á Äõ¸® Áú¹® [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Áßµ¶ 13-06-17 62
 
12345678910