koyachi tsutomu
rtk21****@hotma*****
2005年 9月 15日 (木) 20:03:09 JST
>1) $B%F!<%V%k$N%9%-!<%^(B >2) $BEPO?$5$l$F$$$k%l%3!<%I$NFbMF(B($B:9$7;Y$($J$1$l$P(B) >3) $B4|BT$9$k7k2L$,JV$i$J$$%/%(%j!<(B(SQL$BJ8(B) > >$B$r<($7$FD:$1$k$H860xFCDj$K6a$E$1$k$+$bCN$l$^$;$s!#(B $B-!:G=i$K;n$7$F(BNG$B$@$C$?$H$-$N>e5->pJs(B $B-"%G!<%?%Y!<%9$r:o=|$7!"%G!<%?%Y!<%9:n ＠ .$+$iF1MM$N<j=g$G:#F|;n$7$?%m%0(B $B-#(BLD_LIBRARY_PATH$B$, ＠ _Dj$5$l$F$$$J$+$C$?$?$a$+!)$H;W$$!"@_Dj$7$F:#F|;n$7$?%m(B $B%0(B $B$r0J2<$K<($7$^$9!#(B $B:#F|;n$7$?$b$N$O-"!"-#$N=g$K<B9T$7$^$7$?!#(B $B$$$:$l$b4|BT$7$?7k2L$OJV$C$F$-$^$;$s$G$7$?!#(B $B0J2<!"%m%0ItJ,$,D9$$$G$9$,$h$m$7$/$*4j$$$7$^$9!#(B ("#"$BItJ,$O%3%a%s%H$G$9!#(B) ################################################################################ # # $B-!(B # 1)$B%F!<%V%k%9%-!<%^(B($B<jBG$A(B) # create database sennatest; use sennatest create table articles( id int unsigned not null auto_increment primary key, body text, fulltext(body) ); # # 2)$BF~NO%G!<%?(B # $ cat sennatest use sennatest; insert into articles values (null,"$BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B "), (null,"$B%9%m!<%i%$%U$r;V8~$9$k(BiPod$B$N6/$_(B - CNET Japan"), (null,"HTML, CSS, Photoshop$B$rF1;~$K3X$Y$k%5%s%W%kIU$-%G%6%$%s5-;v!'(B Goodpic"), (null,"jazzanova$B$NF|5-(B - $B8=:_8\LdJ[8n;N$KAjCLCf$G$"$j!"BP1~$K$D$$$F$b8!F$Cf(B "), (null,"mixi$BHs8x<0%K%e!<%9%5%$%H(B - mixi$B$NLdBj?MJ*(BKusakabe$B;a!"6/@)B`2q$K!)(B"), (null,"$B$`$@$E$+$$$K$C$-!i!'%M%C%H>e$G5DO@$r;E3]$1$k;v$K$D$$$F(B"), (null,"$B$O$F$J(B perl $B%O%C%+!<$NJ}!9$K$*J9$-$7$^$9!#6a:"$^$9$^$9NI$$46$8$J(Bperl $B$G$9$,!"$I$N$h$&$J3+H/4D6-$G3+H/$7$F$$$^$9$G$7$g$&$+!#(B"), (null,"$B%7%J%H%i ＠ iBe;R(B - $BEj$2A,$,Ht$S8r$&$J$+$G%@%$%"%j!<$KN)$F$3$b$k!"$H$$$&(B $B0UL#!#(B"), (null,"Going My Way: Skype$B$N2qOC$r(BPodcast$BMQ$KO?2;$9$k>l9g$N ＠ _DjJ}K!(B"), (null,"Kusakabe$B$5$s$,(Bmixi$B$N0lIt!)$rFx$o$7$F$$$k!#H`$K(Bmixi$B6/@)B`2q$,8@$$EO$5(B $B$l$?$N$@!#(B"), (null,"Ringo's Weblog: google$B$H6%9g$7$J$$J}K!(B2 "), (null,"Moleskin Diary - $BEj$2A,$h$j$?$lA,(B"), (null,"$BBh(B38$B2s!!3$30%a%G%#%"$,EA$($?>. ＠ t!&M9@/2r;67`$NI>H=(B - nikkeibp.jp - $BN)(B $B2VN4$N!V%a%G%#%"(B $B%=%7%*(B-$B%]%j%F%#%/%9!W(B"), (null,"$B$[$=$NF|5-(B - $B%U%)!<%`$,JQ99$5$l$?;v$rCN$k(B"), (null,"$BAmA*5s$O$F$J$H8x?&A*5sK!(B:$BKL3$F;$K=;$`9q2H8xL30wF|5-(B "), (null,"$B$O$F$J!"@/E^$r3t<0$K8+N)$F$FAmA*5s7k2L$rM=B,(B - CNET Japan"); # # 3-1)$B8!:w%/%(%j(B($B1Q8l(B) # $ cat sennatest_en use sennatest; select * from articles where match (body) against ('perl'); select * from articles where match (body) against ('Japan'); # # 3-2)$B8!:w%/%(%j(B($BF|K\8l(B) # $ cat sennatest_jp use sennatest; select * from articles where match (body) against ('$B$O$F$J(B'); # # senna-patched mysql$B%5!<%P!<5/F0(B # $ sudo /etc/init.d/mysql-senna.server start Password: # # senna-patched mysql$B%/%i%$%"%s%H5/F0(B # $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.24-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use sennatest; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> describe articles; +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | body | text | YES | MUL | NULL | | +-------+------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> select * from articles; +----+----------------------------------------------------------------------------------------------------------------------------+ | id | body | +----+----------------------------------------------------------------------------------------------------------------------------+ | 1 | $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B | | 2 | $B%9%m!<%i%$%U$r;V8~$9$k(BiPod$B$N6/$_(B - CNET Japan | | 3 | HTML, CSS, Photoshop$B$rF1;~$K3X$Y$k%5%s%W%kIU$-%G%6%$%s5-;v!'(BGoodpic | | 4 | jazzanova$B$NF|5-(B - $B8=:_8\LdJ[8n;N$KAjCLCf$G$"$j!"BP1~$K$D$$$F$b8!F$Cf(B | | 5 | mixi$BHs8x<0%K%e!<%9%5%$%H(B - mixi$B$NLdBj?MJ*(BKusakabe$B;a!"6/@)B`2q$K!)(B | | 6 | $B$`$@$E$+$$$K$C$-!i!'%M%C%H>e$G5DO@$r;E3]$1$k;v$K$D$$$F(B | | 7 | $B$O$F$J(B perl $B%O%C%+!<$NJ}!9$K$*J9$-$7$^$9!#6a:"$^$9$^$9NI$$46$8$J(Bperl $B$G$9$,!"$I$N$h$&$J3+H/4D6-$G3+H/$7$F$$$^$9$G$7$g$&$+!#(B | | 8 | $B%7%J%H%i ＠ iBe;R(B - $BEj$2A,$,Ht$S8r$&$J$+$G%@%$%"%j!<$KN)$F$3$b$k!"$H$$$&(B $B0UL#!#(B | | 9 | Going My Way: Skype$B$N2qOC$r(BPodcast$BMQ$KO?2;$9$k>l9g$N ＠ _DjJ}K!(B | | 10 | Kusakabe$B$5$s$,(Bmixi$B$N0lIt!)$rFx$o$7$F$$$k!#H`$K(Bmixi$B6/@)B`2q$,8@$$EO$5(B $B$l$?$N$@!#(B | | 11 | Ringo's Weblog: google$B$H6%9g$7$J$$J}K!(B2 | | 12 | Moleskin Diary - $BEj$2A,$h$j$?$lA,(B | | 13 | $BBh(B38$B2s!!3$30%a%G%#%"$,EA$($?>. ＠ t!&M9@/2r;67`$NI>H=(B - nikkeibp.jp - $BN)(B $B2VN4$N!V%a%G%#%"(B $B%=%7%*(B-$B%]%j%F%#%/%9!W(B | | 14 | $B$[$=$NF|5-(B - $B%U%)!<%`$,JQ99$5$l$?;v$rCN$k(B | | 15 | $BAmA*5s$O$F$J$H8x?&A*5sK!(B:$BKL3$F;$K=;$`9q2H8xL30wF|5-(B | | 16 | $B$O$F$J!"@/E^$r3t<0$K8+N)$F$FAmA*5s7k2L$rM=B,(B - CNET Japan | +----+----------------------------------------------------------------------------------------------------------------------------+ 16 rows in set (0.01 sec) mysql> ################################################################################ # # $B-"(B # $B%G!<%?%Y!<%9!"%F!<%V%k$r:n$jD>$7$F:F3NG'$7$F$_$k(B # $ sudo /etc/init.d/mysql-senna.server start Password: $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.24-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +-----------+ | Database | +-----------+ | mysql | | sennatest | | test | +-----------+ 3 rows in set (0.00 sec) mysql> drop database sennatest; Query OK, 0 rows affected (0.01 sec) mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.00 sec) mysql> create database sennatest; Query OK, 1 row affected (0.00 sec) mysql> use sennatest; Database changed mysql> create table articles( -> id int unsigned not null auto_increment primary key, -> body text, -> fulltext(body) -> ); Query OK, 0 rows affected (0.01 sec) mysql> quit; $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root < sennatest $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.24-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use sennatest; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from articles; +----+----------------------------------------------------------------------------------------------------------------------------+ | id | body | +----+----------------------------------------------------------------------------------------------------------------------------+ | 1 | $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B | | 2 | $B%9%m!<%i%$%U$r;V8~$9$k(BiPod$B$N6/$_(B - CNET Japan | | 3 | HTML, CSS, Photoshop$B$rF1;~$K3X$Y$k%5%s%W%kIU$-%G%6%$%s5-;v!'(BGoodpic | | 4 | jazzanova$B$NF|5-(B - $B8=:_8\LdJ[8n;N$KAjCLCf$G$"$j!"BP1~$K$D$$$F$b8!F$Cf(B | | 5 | mixi$BHs8x<0%K%e!<%9%5%$%H(B - mixi$B$NLdBj?MJ*(BKusakabe$B;a!"6/@)B`2q$K!)(B | | 6 | $B$`$@$E$+$$$K$C$-!i!'%M%C%H>e$G5DO@$r;E3]$1$k;v$K$D$$$F(B | | 7 | $B$O$F$J(B perl $B%O%C%+!<$NJ}!9$K$*J9$-$7$^$9!#6a:"$^$9$^$9NI$$46$8$J(Bperl $B$G$9$,!"$I$N$h$&$J3+H/4D6-$G3+H/$7$F$$$^$9$G$7$g$&$+!#(B | | 8 | $B%7%J%H%i ＠ iBe;R(B - $BEj$2A,$,Ht$S8r$&$J$+$G%@%$%"%j!<$KN)$F$3$b$k!"$H$$$&(B $B0UL#!#(B | | 9 | Going My Way: Skype$B$N2qOC$r(BPodcast$BMQ$KO?2;$9$k>l9g$N ＠ _DjJ}K!(B | | 10 | Kusakabe$B$5$s$,(Bmixi$B$N0lIt!)$rFx$o$7$F$$$k!#H`$K(Bmixi$B6/@)B`2q$,8@$$EO$5(B $B$l$?$N$@!#(B | | 11 | Ringo's Weblog: google$B$H6%9g$7$J$$J}K!(B2 | | 12 | Moleskin Diary - $BEj$2A,$h$j$?$lA,(B | | 13 | $BBh(B38$B2s!!3$30%a%G%#%"$,EA$($?>. ＠ t!&M9@/2r;67`$NI>H=(B - nikkeibp.jp - $BN)(B $B2VN4$N!V%a%G%#%"(B $B%=%7%*(B-$B%]%j%F%#%/%9!W(B | | 14 | $B$[$=$NF|5-(B - $B%U%)!<%`$,JQ99$5$l$?;v$rCN$k(B | | 15 | $BAmA*5s$O$F$J$H8x?&A*5sK!(B:$BKL3$F;$K=;$`9q2H8xL30wF|5-(B | | 16 | $B$O$F$J!"@/E^$r3t<0$K8+N)$F$FAmA*5s7k2L$rM=B,(B - CNET Japan | +----+----------------------------------------------------------------------------------------------------------------------------+ 16 rows in set (0.00 sec) mysql> quit; $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root < sennatest_en id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root < sennatest_jp id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B koyachi ＠ sp1200:~/tmp$ ################################################################################ # # $B-#(B # LD_LIBRARY_PATH$B ＠ _Dj$7$F:F3NG'(B # $ su Password: $ printenv SHELL=/bin/bash TERM=vt100 JLESSCHARSET=japanese-euc SSH_CLIENT=::ffff:219.97.22.57 1127 22 SSH_TTY=/dev/pts/0 USER=root LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.ogg=01;35:*.mp3=01;35:*.wav=01;35: PAGER=lv PATH=/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/bin/X11:/usr/local/sbin:/usr/local/bin MAIL=/var/mail/koyachi PWD=/home/koyachi/tmp LANG=ja_JP.eucJP TZ=JST-9 PS1=\h:\w\$ HOME=/root SHLVL=2 LANGUAGE=ja_JP:ja:en_GB:en LV=-Oej LOGNAME=koyachi SSH_CONNECTION=::ffff:219.97.22.57 1127 ::ffff:192.168.0.101 22 _=/usr/bin/printenv $ export LD_LIBRARY_PATH="/usr/local/mecab-0.81-senna/lib:/usr/local/senna/lib:/usr/local/mysql-4.0.24-senna/lib:/lib:/usr/lib:/usr/local/lib" $ printenv SHELL=/bin/bash TERM=vt100 JLESSCHARSET=japanese-euc SSH_CLIENT=::ffff:219.97.22.57 1127 22 SSH_TTY=/dev/pts/0 USER=root LD_LIBRARY_PATH=/usr/local/mecab-0.81-senna/lib:/usr/local/senna/lib:/usr/local/mysql-4.0.24-senna/lib:/lib:/usr/lib:/usr/local/lib LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.ogg=01;35:*.mp3=01;35:*.wav=01;35: PAGER=lv PATH=/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/bin/X11:/usr/local/sbin:/usr/local/bin MAIL=/var/mail/koyachi PWD=/home/koyachi/tmp LANG=ja_JP.eucJP TZ=JST-9 PS1=\h:\w\$ HOME=/root SHLVL=2 LANGUAGE=ja_JP:ja:en_GB:en LV=-Oej LOGNAME=koyachi SSH_CONNECTION=::ffff:219.97.22.57 1127 ::ffff:192.168.0.101 22 _=/usr/bin/printenv $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root < sennatest_en id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B $ /usr/local/mysql-4.0.24-senna/bin/mysql --host=localhost --socket=/usr/local/mysql-4.0.24-senna/tmp/mysql.sock -u root < sennatest_jp id body 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B 1 $BM9CyL11D2=$O=EMW$JLdBj$@$H;W$&(B ---- koyachi
