HTML
Javascript
Flash Actionscript
PHP
mySQL
ASP
MS-SQL
Linux
Others
Ziwoo Board
Portfolio
About
|
|
Ziwoo Board |
ÀÛ¼º |
2006-10-12 14:46:50 Ãßõ: 0 Á¶È¸: 2427 |
Á¦¸ñ |
±â´ÉÀûÀκκп¡¼ Á¦ÀÛÀÚ´Ô¿¡°Ô ÇÔ Á¶¾ð ±¸Çغ¾´Ï´Ù. |
À̸§(ID) |
Áú¹®ÀÚ (218.152.151.29)
|
|
|
³×À̹ö¿¡ ¿äÁò¶ß´ÂÀ̾߱âó·³...
¸ðµç °Ô½ÃÆÇÁß¿¡¼ Á¶È¸¼ö°¡ ³ôÀº ±ÛÀ» ±¸ÇÒ¼ö ÀÖÀ»±î Çؼ ÀÔ´Ï´Ù.
ÀÌ·¡Àú·¡ »ý°¢À» Çغôµ¥ zbÅ×ÀÌºí¿¡ boardid°¡ ÀÖÀ¸´Ï Á¶Àεµ ºÒ°¡ÇÒ²¨°°°í...
°¢°Ô½ÃÆǸ¶´Ù Á¶È¸¼ö Á¦ÀϳôÀ»°Å Çϳª¾¿¸¸ °¡Á®¿Í¼ »Ñ¸®ÀÚ´Ï..
ÃëÁö¿¡ Á¶±Ý ¾î±ß³ª°í...¶ÇÇÑ 10°³ÀÌ»óÀÇ Å×À̺íÀÌ Àִµ¥ 10°³ÀÌ»óÀÇ Äõ¸®¸¦ ³¯¸°´Ù´Â°Ô
¸î°³ÀÇ ±ÛÀ» Ãâ·ÂÇϱâ À§Çؼ...ºÎÇÏ°¡ °É¸®´Â°É ¿øÄ¡¾Ê°í...
°¢°Ô½ÃÆÇÅ×ÀÌºí¿¡ ÀÚ½ÅÀÇ Å×À̺í¸í°ú °°Àº boardid¶ó´Â Çʵ带 »ý¼ºÈÄ¿¡...
zb¿Í left outer join Çؼ °¡Á®¿À´Â ¹æ¹ýÀÌ ÀÖÀ»²¨°°Àºµ¥...
10°³ÀÌ»óÀÇ ¸ðµç °Ô½ÃÆÇÀ» ÇÏÁö ¾Ê°í ƯÁ¤ 5°³Á¤µµÀÇ °Ô½ÃÆǸ¸ Ãß·Á¼ ÇßÀ»°æ¿ì...
°ÔÇdzªÅ×À̺í 5°³ + zb Å×À̺íÁ¶ÀÎ Çؼ hit¼ö¿¡ order by desc ÇÏ°í limit 5°³Á¤µµÇßÀ»°æ¿ì..
°Ô½Ã±Û ¸î°³±îÁö -_-a ¹®Á¦¾øÀÌ ¹öÅßÁÙ±î¿ä...
±×¸®°í ¹¹ ÀÌ·± °£´ÜÇÑ°ÅÁö¸¸ Áö¿ìº¸µå ÃëÁö¿¡ ¸Â°Ô »ç¿ëÀÚµéÀÌ Æ©´×ÇÑ°Í¿¡ ´ëÇØ
ÀÇ°ß°øÀ¯ ÇÒ¼ö Àִ°ԽÃÆÇ Ãß°¡Çغ¸½Ã´Â°Ç ¾î¶°½Ç·±Áö¿ä?? Á¤¸» ÃʱÞÀÚ¸¸ ¾Æ´Ï¶ó¸é
³ª¸§´ë·Î ÀÚ±âÀÔ¸À¿¡ ¸Â°Ô Æ©´×ÇÏ¿© »ç¿ëÇÒ¼ö ÀÖµµ·Ï °£°áÇÔ°ú ÃÖ¼ÒÇÔÀ» °Á¶ÇÏ¿©
Á»´õ º¸ÆíÈ ½Ãų¼ö ÀÖµµ·Ï ^^
ÀÌ°Í¿¡ ´ëÇÑ Äõ¸®´Â
alter table zb_test add boardid varchar (30) not null default 'zb_test';
select b.boardid,b.uid,b.subject from zb a left outer join zb_test b on (a.boardid=b.boardid);
¹¹ ÀÌ·±½ÄÀÌ µÇ´Â°ÅÁÒ..°Ô½ÃÆǵéÁß Á¶È¸¼ö³ôÀº¼øÀ¸·Î »Ì¾Æ¿Ã Ÿ°Ù°Ô½ÃÆÇ µðºñ¿¡¸¸
boardidÃß°¡½ÃÅ°°í »Ì¾Æ¿À´ÂºÎºÐ¿¡ left join¸¸ Ãß°¡½ÃÅ°¸é µÉÅÙµ¥..
|
|
|
|
Áö¿ì(ziwoo)
2006-10-12 17:48:25
|
|
union ¿¡ ´ëÇؼ °Ë»öÇغ¸¼¼¿ä. |
|
|
|
|
|