|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0
0
UnderTech
Ä¿¼¸¦ ¾²´Â °æ¿ì´Â º¹¼ö°³ÀÇ µ¥ÀÌŸ¸¦ °Çº°·Î ´ÜÀÏ Äõ¸®·Î´Â ÇÏÁö ¸øÇÏ´Â ·ÎÁ÷ 󸮸¦ ÇÒ¶§ÀÔ´Ï´Ù. ¿¹¸¦ µé¾î Àç°í ó¸® µî.
°Á Äõ¸® ¾²¼¼¿ä..INSERT..SELECT µîÀ¸·Î.
2020-09-06
|
0
0
²¿¸¶À̽´
insert into test1 select id, max(gender) as gender, max(age) as age, max(agefroup) as agegroup, max(music) as music, max(sports) as sports, reg_date from( select id, case when gubun='gender' then desc else '' end as gender, case when gubun='age' then desc else '' end as age, case when gubun='agegroup' then desc else '' end as agegroup, case when gubun='music' then rate else 0 end as music, case when gubun='sports' then rate else 0 end as sports, reg_date from interest)a group by id, reg_date
´ëÃæ ŸÀÚÄ£°Å¶ó ¿ÀŸ´Â ¾çÇظ¦...
2020-09-11 *
|
0
0
¸²Àå»ç
Ä¿¼´Â ¾²´Â ¼ø°£ ±×¶§ºÎÅÍ ´Ü´ÜÈ÷ ¸¶À½°¡ÁüÀ» °¡Á®¾ß ÇÕ´Ï´Ù....
Àß µ¹¾Æ°¡¸é ¹®Á¦ ¾øÁö¸¸ ¹®Á¦°¡ »ý±â¸é º¹±¸µµ ¾î·Æ°í ºÐ¼®µµ ¾î·Æ°í.... ³í¸® ¸ðµ¨¸µÀ» ÀßÇϼ̴ٸé Ä¿¼¸¦ ¾µÀÏÀÌ ¾ø´Âµ¥ Á¶ÀÎÀÌ ¾ÈµÈ´Ù¸é ¿Ö Á¶ÀÎÀÌ ¾ÈµÇ°í ¾ÕÀ¸·Î ¸ðµ¨¸µÀ» ¾î¶»°Ô ÇØ¾ß ÇÏ´ÂÁö ¸¹Àº °í¹ÎÀ» Çغ¸½Ã±â ¹Ù¶ø´Ï´Ù
2020-09-11 *
|
0
0
[* ºñȸ¿ø *]
Ä¿¼´Â µÇµµ·Ï insert µÇ´Â Å×À̺í ÇüÅÂ¿Í À¯»çÇÏ°Ô ¸¸µé¾î¼ fetchÇÏ´Â°Ô ÆíÇØ¿ä
Ä¿¼°¡ Å×ÀÌºí ±¸Á¶¶û ´Ù¸£¸é µð¹ö±ë ÇÒ¶§µµ Çì±ò¸®°í °ª µÚÁö´Â°Íµµ ÀÏÀ̱ä ÇÕ´Ï´Ù.
2020-09-21 *
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â |
±»ÀÌ Ä¿¼¸¦ ¿Ö?