Q&A
  • DB Q&A
Á¶Àι® Áú¹®( ȸ¿øÅ×À̺í, °áÁ¦Å×À̺í)
±Û¾´ÀÌ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°í·¡82 ³¯ Â¥ 12-04-19 17:52 Á¶ ȸ 499
°£ÆíURL http://phpschool.com/link/qna_db/187021 º¹»ç

SyntaxHighlight·Î º¸±â

´äº¯Ã¤ÅÃÀ² 100 %
°áÁ¦ Á¤º¸ Å×À̺í À̸§: a, Çʵå´Â> no, member, price date
ȸ¿øÁ¤º¸ Å×À̺í À̸§: b,  Çʵå´Â> no, id, name

no ´Â ¿ÀÅäÀÎÅ©¸®¸ÕÆ® ·Î 1¾¿ Áõ°¡ µÇ°í¿ä(¾çÂʸðµÎ)
°áÁ¦ Á¤º¸ Å×À̺íÀÇ member Àº ȸ¿øÁ¤º¸Å×À̺íÀÇ no °ªÀ» ÀúÀå Çϰí ÀÖ½À´Ï´Ù.

¿©±â¼­ °áÁ¦ Á¤º¸ Å×À̺íÀÇ ¸ñ·ÏÀ» ºÒ·¯ ¿À´Âµ¥
ȸ¿øÀÇ À̸§±îÁö °°ÀÌ ºÒ·¯ ¿Ã·Á¸é ¾î¶»°Ô ÇØ¾ß µÇ³ª¿ä..

Àú´Â Áö±Ý
$query = "select * from a";
$result = mysql_query($query);

where( $data = mysql_fetch_array($query) ){
  $query = mysql_query("select name from a where no = $data[member]");
  $name = mysql_resylt($query, 0, 0);
}
ÀÌ·±½ÄÀ¸·Î Ãâ·ÂÀ» Çϰí ÀÖ½À´Ï´Ù.
ÇѹøÀÇ Äõ¸®·Î ÇØ°áÇÏ´Â Á¶Àι®Á» ¾Ë·ÁÁÖ¼¼¿ä
°¨»çÇÕ´Ï´Ù.

Àüü´ñ±Û¼ö 3

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¶óÀ̺귯¸® 12-04-19 17:59

    ¼Ò½ºº¸±â

  • select a.*, b.name from °áÁ¦ as a inner join ȸ¿ø as b on a.no=b.member
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°í·¡82 12-04-19 18:50

    ¼Ò½ºº¸±â

  • ´ñ±ÛºÎÅÍ ´Þ°í Å×½ºÆ® ÇØºÃ´Âµ¥ Àß µÇ³×¿ä..Á¤¸» °¨»çÇÕ´Ï´Ù.¤¾¤¾
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°í·¡82 12-04-19 18:46

    ¼Ò½ºº¸±â

  • ¾Æ °¨»çÇÕ´Ï´Ù..^^
  • °Ô½Ã¹° 72,438°Ç RSS
¹øÈ£´äº¯Á¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
°øÁö - [Çʵ¶»çÇ×]Q&A °Ô½ÃÆÇ ±ÔÄ¢ [28] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ä¿ÇÇÇÑÀÜ 08-10-01 114313
72,258 ´äº¯¿Ï·á REPLICATION ¿î¿µÁß 2¹ø¿¡¼­ backupÇÒ¶§ 1,2 ¼­¹ö ¼­·Î ¿µÇâÀ» ¡¦ [1] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÂоÆ21 13-05-22 108
72,257 ´äº¯ÁøÇà °ÔÀÓ ¸®±×¿Àºê·¹ÀüµåÀÇ ÀüÀû°Ë»ö ¼­ºñ½º¸¦ ÇϰíÀÖ½À´Ï´Ù DB µ¥ÀÌ¡¦ [4] ÷ºÎÆÄÀÏ Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹®¼º±Ç 13-05-22 189
72,256 ´äº¯ÁøÇà ¿ÜºÎ¼­¹ö Å×À̺í join Çϱâ [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ä£ÀýÇѾӸ¶ 13-05-21 146
72,255 ´äº¯¿Ï·á ÇØ´ç ÇʵåÀÇ ¿ª¼ø°ª ±¸Çϱâ [4] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§lililiillililii 13-05-21 107
72,254 ´äº¯ÁøÇà µÎ°³ÀÇ Å×À̺í Á¶ÀÎÇØ¼­ ÇÕ°Ô ³»´Â°Ô Àß¾ÈµÇ³×¿ä ¤Ð [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÆÄÄÚ 13-05-21 113
72,253 ´äº¯ÁøÇà ¸ð¹ÙÀϽð£ÀÌ Áö³ª¸é Å×ÀÌºí ³»¿ëÀÌ ÀÚµ¿¼Ò¸ê ±â´ÉÀº ¾î¶»°Ô ±¸ÇöÇϴ¡¦ [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ÅÀ̳»¸°¹úóÄÁÆ®·Ñ 13-05-21 120
72,252 ´äº¯ÁøÇà apm-setup7 ¼³Ä¡ÈÄ ÇÑ´Þ Á¤µµ 됬´Âµ¥ mysql5°¡ ½ÇÇàµÇÁö ¡¦ [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Á©¶ó¼î 13-05-21 101
72,251 ´äº¯ÁøÇà mysql innodb »óꏱâÀÔ´Ï´Ù. Áú¹®ÀÌ¿ä^^ [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹Ì¶óŬ 13-05-21 118
72,250 ´äº¯ÁøÇà mysql¿¡¼­ like¿Í =ÀÇ Â÷À̰¡ ¹«¾ùÀÎÁö¿ä? [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Karan 13-05-21 97
72,249 ´äº¯¿Ï·á set old_passwords=1 ÀÌ °©Àڱ⠾ȸÔÈü´Ï´Ù. [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§µ¶°Åû³â 13-05-21 91
72,248 ´äº¯¿Ï·á insert into °ü·Ã ¹®ÀǸ¦ µå¸³´Ï´Ù. [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹Ì¸®ÀÌ 13-05-21 103
72,247 ´äº¯¿Ï·á ÀÌ·±½ÄÀÇ ¾÷µ¥ÀÌÆ®¹®À» ½áµµµÇ³ª¿ä? [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°³¹ßÃÊÂ¥ 13-05-21 83
72,246 ´äº¯¿Ï·á Çʵ尪À» ÇѲ¨¹ø¿¡ º¯°æ(update)ÇÏ´Â ¹æ¹ý¹®Àǵ帳´Ï´Ù. [9] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§hero412 13-05-21 114
72,245 ´äº¯¿Ï·á Äõ¸®Áú¹®Á»¿ä [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¿µµîÆ÷¾ç¾Æ¸® 13-05-21 96
72,244 ´äº¯ÁøÇà °Ë»ö¼Óµµ°¡ ³Ê¹« ´À·Á¿ä.. °ÅÁø 20ºÐ... [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹Ì¶óŬ 13-05-21 126
72,243 ´äº¯¿Ï·á ¼Ò¼öÁ¡ ÀÚ·áÇü [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§bamsong2 13-05-21 93
72,242 ´äº¯ÁøÇà DBºÎÇÏ ÁÙÀÌ´Â ¹æ¹ý (»çÀÌÆ®°¡ ±âÇüÀûÀ¸·Î DB»ç¿ë·ü¸¸ ³ô¾Æ¿ä) [3] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¶Ñ¶Ñ 13-05-20 159
72,241 ´äº¯¿Ï·á MYSQL DB Çʵ尳¼ö¿¡ °üÇÏ¿©.... [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÄÚÇÇÇ¢ 13-05-20 122
72,240 ´äº¯ÁøÇà asp¿¡¼­ ÇÁ·Î½ÃÁ® È£Ãâ Áú¹®ÀÌ¿ä [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ê¹Ì 13-05-20 96
72,239 ´äº¯¿Ï·á mssql select ¹® Áú¹® [3] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Sene 13-05-20 123
 
12345678910