|
Total related article : 3 |
|
µî·ÏÀÏ: | 2001-06-16 |
½Ã°£: | 20:03:27 |
Á¶È¸¼ö: | 3172 |
from: | 211.33.56.250 |
|
[Áú¹®] mysql¿¡¼ °Ë»öÇßÀ»¶§... blobÀÇ ¹®Àå¿¡¼... |
±Û¾´ÀÌ : Anonymous |
|
°Ô½ÃÆÇÀÇ °æ¿ì blobÀ¸·Î º»¹®À» ¸¸µé¾î µÐ´Ù°í Çϸé... º»¹® °Ë»öÀ» ÇÏ¿© blob¹® ¾È¿¡¼ '¾È³ç' À̶ó´Â ´Ü¾î¸¦ ã½À´Ï´Ù. À̶§ ¾È³çÀ» Æ÷ÇÔÇÏ¿© ¾à 30±ÛÀÚÀÇ ±ÛÀÚ¸¦ ...
... ±×¿¡°Ô ¾È³ç À̶ó°í ¸»ÇÏ°í µ¹¾Æ¼¹´Ù ...
¿Í °°Àº ½ÄÀ¸·Î Ç¥ÇöÇÏ·Á¸é ¾î¶»°Ô ÇÏÁÒ? ¿ä¾àÇϸé mysql¿¡¼ °Ë»öÇßÀ»¶§ °Ë»ö¹®À» ±âÁØÀ¸·Î Á¿ì x±ÛÀÚ¸¸ÅÀÇ ¹®ÀåÀ» »Ì¾Æ³»¼ Ãâ·ÂÇÒ¶§.... ÀÌ´Â perl·Î ±¸ÇöÇÏ·Á°í ÇÕ´Ï´Ù.
±×¸®°í¿ä...blobÀº indexÁ¤ÀÇ ÇÒ¼ö ¾ø´Â°Ì´Ï±î?
|
|
   |
|
µî·ÏÀÏ: | 2001-06-19 |
½Ã°£: | 12:06:40 |
Á¶È¸¼ö: | 9772 |
from: | 211.33.8.94 |
|
[´äº¯] [Áú¹®] mysql¿¡¼ °Ë»öÇßÀ»¶§... blobÀÇ ¹®Àå¿¡¼... |
±Û¾´ÀÌ : vopos |
|
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
>°Ô½ÃÆÇÀÇ °æ¿ì blobÀ¸·Î º»¹®À» ¸¸µé¾î µÐ´Ù°í Çϸé... >º»¹® °Ë»öÀ» ÇÏ¿© blob¹® ¾È¿¡¼ '¾È³ç' À̶ó´Â ´Ü¾î¸¦ ã½À´Ï´Ù. >À̶§ ¾È³çÀ» Æ÷ÇÔÇÏ¿© ¾à 30±ÛÀÚÀÇ ±ÛÀÚ¸¦ ... > > ... ±×¿¡°Ô ¾È³ç À̶ó°í ¸»ÇÏ°í µ¹¾Æ¼¹´Ù ... > >¿Í °°Àº ½ÄÀ¸·Î Ç¥ÇöÇÏ·Á¸é ¾î¶»°Ô ÇÏÁÒ? >¿ä¾àÇϸé mysql¿¡¼ °Ë»öÇßÀ»¶§ °Ë»ö¹®À» ±âÁØÀ¸·Î Á¿ì x±ÛÀÚ¸¸ÅÀÇ >¹®ÀåÀ» »Ì¾Æ³»¼ Ãâ·ÂÇÒ¶§.... ÀÌ´Â perl·Î ±¸ÇöÇÏ·Á°í ÇÕ´Ï´Ù.
Á¤±ÔÇ¥Çö½Ä(regular expression)¿¡ ´ëÇÑ Áö½ÄÀÌ ÇÊ¿äÇÒ µí ÇÕ´Ï´Ù. ÇØÇÇÆ÷·³¿¡µµ ¾îµð¿£°¡ ¼³¸íÀÌ ÀÖÀ¸´Ï ã¾Æº¸½Ã°í, Á¦°¡ ¾Ë°íÀÖ´Â ±âÃʸ¦ ¼³¸íÇصРÆäÀÌÁö¸¦ ¸µ Å© ½ÃÄѵ帳´Ï´Ù.
http://www.phpschool.com/bbs/view.html?id=2278&code=tnt&start=0 http://www.devshed.com/Server_Side/Administration/RegExp/ http://www.phpbuilder.com/columns/dario19990616.php3 http://www.mysql.com/doc/P/a/Pattern_matching.html http://public.yahoo.com/~jfriedl/regex/links.html
>±×¸®°í¿ä...blobÀº indexÁ¤ÀÇ ÇÒ¼ö ¾ø´Â°Ì´Ï±î?
TEXT, BLOB ÇüÅ´ MySQL¿¡¼ INDEX°¡ µÇÁö ¾Ê´õ±º¿ä. ¾Æ¸¶ µ¥ÀÌŸ Å©±â°¡ Å©±â ¶§¹®ÀÌ ¾Æ´Ñ°¡ »ý°¢µÇ´Âµ¥¿ä.
MySQL 3.23.23 ÀÌÈĺÎÅÍ´Â VARCHAR, TEXT ·Î Á¤ÀÇµÈ Ä÷³À» À妽º ÇÒ ¼ö ÀÖ´Ù°í µÇ¾î Àִµ¥ Çѹø Çغ¸½Ã°í ±ÛÁÖ¼¼¿ä.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
°¨»çÇÕ´Ï´Ù.
- vopos
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
   |
|
µî·ÏÀÏ: | 2001-06-19 |
½Ã°£: | 17:57:00 |
Á¶È¸¼ö: | 3185 |
from: | 211.229.87.33 |
|
      [´äº¯] [´äº¯] [Áú¹®] mysql¿¡¼ °Ë»öÇßÀ»¶§... blobÀÇ ¹®Àå¿¡¼ |
±Û¾´ÀÌ : Anonymous |
|
¾È³çÇϼ¼¿©....
#!/usr/bin/perl
$STR = 'ÀÔ·ÂÀ» ¹Þ´Â´Ù. scanfÇÔ¼öµµ printf¿Í ¸¶Âù°¡Áö·Î ¼½Ä ¹®ÀÚ¿À»';
@Name = ($STR =~ /(.{10})ÇÔ¼öµµ(.{10})/); print $Name[0],"ÇÔ¼öµµ",$Name[1];
À§¿Í °°Àº ÇÁ·Î±×·¥À» ¸¸µé¾úÀ»¶§... ÇÔ¼öµµ ¿ÞÂÊÀÇ ±ÛÀÚ°¡ '´Â´Ù' ºÎºÐ¿¡¼ ÇѱÛÀÌ Àß·Á¼ ±úÁý´Ï´Ù. ÇѱÛÀÌ 2¹ÙÀÌÆ®¶ó ±×·±µ¥¿ä... À̸¦ ÇØ°áÇÒ ¼ö Àִ¹æ¹ýÀº ¾ø½À´Ï±î? ¹¹.... ¿ÇÁö ¾ÊÀº ¹®ÀÚ¸¦ º¯Çü½ÃŲ´Ù´ø°¡.... ¾Æ´Ï¸é Á¤±Ô½Ä¿¡¼....
Á¤¸» ¼ö°í¸¦ µå·Á Á˼ºÇÔµÂ...
|
|
   |