石橋卓見
ishib****@syste*****
2012年 3月 29日 (木) 22:03:43 JST
$B$O$8$a$^$7$F!#(B
$B3t<02q<R%7%9%F%`%=%U%H!!@P66$H?=$7$^$9!#(B
$BJ?;~$h$j!"A4J88!:w%(%s%8%s(Bgroonga$B!"(Bmroonga$B$r6HL3$KMxMQ$5$;$F$$$?$@$$$F(B
$B$*$j$^$9!#(B
$BM-MQ$J%=%U%H%&%'%"$r$4Ds6!D:$-K\Ev$K$"$j$,$H$&$4$6$$$^$9!#(B
$B$5$F!":#2s!"2<5-$N>I>u$K$D$$$F$4AjCL$r$5$;$FD:$-$?$/!"$h$m$7$/$*4j$$$$(B
$B$?$7$^$9!#(B
<$B>I>u(B>
TwitterStreamingAPI$B$N%5%s%W%k%G!<%?$rO"B3$GEPO?$9$k=hM}$r9T$J$C$F$$$k(B
$B:GCf$K!"A4J88!:w$r9T$$!"2<5-$N%(%i!<$,H/@8$7$^$7$?!#(B
<$B%(%i!<%a%C%;!<%8(B>
$B%(%i!<%3!<%I!'(B1032 [MySQL][ODBC 5.1 Driver][mysqld-5.1.61]Can't find record in 'table1'
<$B%(%i!<$NH/@8>r7o(B>
$B-!A4J88!:w%+%i%`$r;}$D%F!<%V%k$K!"O"B3$7$F%F%-%9%H%G!<%?$rEjF~!#(B
$B!!"(#1#0%/%(%j!?KhIC0L$G$7$g$&$+!#(B
$B-"$^$5$K(BINSERT$B$7B3$1$F$$$k>u67$G!"$=$N%F%-%9%H%G!<%?$K$?$^$?$^4^$^$l$k(B
$B!!J8;zNs$r(BSELECT$B!A(BMATCH$B!A(BAGAINST$B$GA4J88!:w$9$k$H!"2<5-%(%i!<$,H/@8$9$k!#(B
$B-#A4J88!:w$K;HMQ$7$?%/%(%j$O!"B>$N%F!<%V%k$H(BJOIN$B$7$F$$$k!#(B
$B!!(BJOIN$B$;$:!"C1FH$G(BSELECT$B!A(BMATCH$B!A(BAGAINST$B$GA4J88!:w$7$F$b%(%i!<$OH/@8(B
$B!!$7$J$$!#(B
$B-$A4J88!:w$K;HMQ$7$?%/%(%j$N8!:w%o!<%I$O#1J8;z$G$"$j!"#2J8;z0J>e$@$H(B
$B!!%(%i!<$OH/@8$7$J$$!#(B
$B-%(BORDER BY$B6g$,$J$$$H%(%i!<$OH/@8$7$J$$!#(B
$B"(-"$r:F8=$9$k$?$a$K!"2<5-$N$h$&$JF10l$N%G!<%?$rO"B3(BINSERT$B$7$F$$$k:GCf$K(B
$B!!8!:wMQ%/%(%j$rEj$2$k$H!"$[$\Kh2s:F8=$7$^$7$?!#(B
<$BO"B3EjF~$7$F$$$k%/%(%j(B>
insert into table1
(col1,col2,col3,col4,col5,col6,col_text,col8,col9)
values ($B!D>JN,!D(B,"$B;d$OHh$l$^$7$?(B",$B!D>JN,!D(B);
<$B8!:wMQ%/%(%j(B>
SELECT
*
FROM
table1 left join table2 on table1.id = table2.id
WHERE
MATCH(table1.col_text) AGAINST('$B$l(B')
ORDER BY
table1.id
<$B%(%s%8%s(B>
ENGINE = groonga
COMMENT = 'engine "innodb"'
DEFAULT CHARSET utf8;
<$B%"%W%j%1!<%7%g%s$N%P!<%8%g%s(B>
OS$B!'(BCentOS6.2 x86_64
$B%Q%C%1!<%8!'(B
groonga-libs-2.0.0-0.el6.x86_64
groonga-repository-1.0.0-0.noarch
groonga-devel-2.0.0-0.el6.x86_64
groonga-tokenizer-mecab-2.0.0-0.el6.x86_64
groonga-2.0.0-0.el6.x86_64
groonga-plugin-suggest-2.0.0-0.el6.x86_64
mysql-5.1.61-1.el6_2.1.x86_64
mysql-server-5.1.61-1.el6_2.1.x86_64
mysql-devel-5.1.61-1.el6_2.1.x86_64
mysql-libs-5.1.61-1.el6_2.1.x86_64
mysql-mroonga-2.00-0.el6.x86_64
php-mysql-5.3.3-3.el6_2.6.x86_64
$B$*K;$7$$$H$3$m62=L$G$9$,!"$*NO$rB_$7$FD:$-$?$/!"$I$&$>(B
$B$h$m$7$/$*4j$$CW$7$^$9!#(B
$B"!(B $B ＠ P66(B $BBn8+(B / Takken Ishibashi
$B""(B $B3t<02q<R(B $B%7%9%F%`%=%U%H(B
$B""(B $B%7%9%F%`;v6HIt(B / $B%7%9%F%`3+H/#3It(B
$B""(B Tel:03-5776-5910 / Fax:03-5776-5919
$B"!(B mailto:ishib****@syste*****