|
||
0
0
¾Ó±×¸£¸£2
* ÁÁ¾ÆÇÏÁö ¸¶¼¼¿ä. ³ªÁß¿¡ À¯Áöº¸¼ö Çϴ»ç¶÷ Èûµé¾î¿ä. Áö±Ý ´çÀå ÀÌÇØ´Â ¾ÈµÇ´õ¶óµµ Ä÷³¸í Çϳª Çϳª Àû¾îÁÖ´Â°Ô ÁÁ´Ù°í ¿Ü¿ì¼¼¿ä^^
|
0
0
¼ú°ªÀº³»°¡³¾²²
´äº¯ ´Ùµé °¨»çÇÕ´Ï´Ù~
|
0
2
craveu
ÄÚµå Å×ÀÌºí µû·Î ¸¸µé¾î¼ Á¶ÀÎÇÏ´Â ¹æ½ÄÀ» ÃßõÇÕ´Ï´Ù.
|
0
1
ÀÌ ºÐ ¸»¾¸ ó·³ ÄÚµå Å×ÀÌºí µû·Î Àâ°í ÇÏ½Ã´Â°Ô Á¤¼®ÀÌÁÒ..
Çϵå ÄÚµùÀÌ µé¾î°¡¸é À¯Áöº¸¼ö°¡ Èûµé¾îÁöÁÒ.. |
0
0
¼ú°ªÀº³»°¡³¾²²
DB Á¢ÇÑÁö ¾ó¸¶ µÇÁö ¾Ê¾Æ ¸ð¸£´Â ºÎºÐÀÌ ¸¹½À´Ï´Ù. ¹æ±Ý ±¸±Û¸µ ³×À̹ö °Ë»öÇغÁµµ Àß Á¤¸®°¡ µÇÁö ¾Ê¾Æ, ÀÚ¼¼È÷ ¼³¸íÇØÁֽǼö ÀÖ³ª¿ä?
°¨»çÇÕ´Ï´Ù. Ãßõ1µûºÀ µå¸³´Ï´Ù. |
0
0
[* ºñȸ¿ø *]
º¸Åë
CODE_H, DESCRIPTON Çì´õÅ×À̺í CODE_H, CODE_D, NAME, DESCRIPTION µðÅ×ÀÏÅ×À̺í ÀÌÁ¤µµ¸¸ ÀÖ´Â Å×ÀÌºí¿¡ CODE_H = '000', DESCRIPTION = '»ç¿ëÀÚ±ÇÇÑ' CODE_H = '000' CODE_D = '0' NAME = '»ç¿ëÀÚ' CODE_H = '000' CODE_D = '1' NAME = '°ü¸®ÀÚ' ÀÌ·±½ÄÀ¸·Î ³Ö¾î³õÁÒ ±×¸®°í ÇÔ¼ö°°Àº°Å Çϳª ¸¸µé¾î¼ ÀÌ°É ¼¿·¢Æ®ÇØ¿À¸é ±ÍÂú°Ô ġȯ ¾ÈÇØÁ൵ µÇ¼ ÆíÇÏÁÒ |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |
from user
, sex
, CASE authority WHEN 0 THEN '»ç¿ëÀÚ' WHEN 1 THEN '°ü¸®ÀÚ' END AS authority
FROM user
ÀÌ·¸°Ô »ç¿ë°¡´ÉÇϰڳ׿ä
¸¸¾à Ä®·³ÀÌ ¼ö½Ê°³°¡ »ý°åÀ»¶§ ÀÏÀÏÀÌ Ä®·³¸í ´Ù Ãļ Á¤ÀÇÇؾßÇϳª¿ä?
¾Æ´Ï¸é * ·Î Ç¥ÇöÇؼ ƯÁ¤ Ä®·³¸í¸¸ ġȯÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀÌ ÀÖ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù~
Àý´ë ±×·¯Áö ¸¶¼¼¿ä
°¢Á¾ ÅؽºÆ®ÆíÁý±â³ª ÇÏ´Ù¸øÇØ ¿¢¼¿À» ½áµµ 5ºÐÀÌ¸é ³¡³ª´Â °É ±ÍÂú¾Æ¼ * ·Î ¾²½Ã¸é ¾ÈµÇ¿ä