石橋卓見
ishib****@syste*****
2012年 3月 30日 (金) 13:56:59 JST
$B%7%9%F%`%=%U%H ＠ P66$G$9!#$*@$OC$K$J$j$^$9!#(B $B ＠ hF|Ej9F$5$;$FD:$-$^$7$?!"O"B3(BINSERT$B;~$K%(%i!<$H$J$k7o$G#1E@!"8m$j$,(B $B$"$C$?$3$H$H!"DI2C$G3NG'$G$-$?FbMF$r!"$4Js9p$5$;$F$$$?$@$-$^$9!#(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"(>e5-$K$D$-$^$7$F$O!"#2J8;z0J>e$N#nJ8;z$G$bH/@8$9$k$3$H$r3NG'$7$^$7$?!#(B $B-&(BSTART TRANSACTION$B!"(BCOMMIT$B4V$K$*$$$F(BINSERT$B$7$F$$$k%F%-%9%H$N$9$Y$F$H(B $B!!8!:wBP>]$NJ8;zNs$,0lCW$7$?>l9g$KH/@8$7$F$*$j$^$9!#(B $B!!$^$?%H%i%s%6%/%7%g%s$r;HMQ$7$J$$!J(BAutoCommit$B!K$N>uBV$G$bH/@8IQEY$ODc$$(B $B!!$G$9$,!"%(%i!<$OH/@8$7$^$9!#(B $B-'0lEY$G$bH/@8$7$?>l9g!"(BINSERT$B$7$F$$$k%F%-%9%H$H%j%"%k%?%$%`$K0lCW$7$J(B $B!!$/$F$b!"0J9_!"8!:w$K;HMQ$7$?J8;zNs$K$*$1$kA4J88!:w$OA4$F<:GT$7$^$9!#(B $B-((BRepair table table1 $B$r<B9T$9$k$H!"@5>o$KF0:n$7$^$9!#(B $B$*K;$7$$Cf62=L$G$9$,!"$I$&$>$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***** >On Thu, 29 Mar 2012 22:03:43 +0900 >$B ＠ P66Bn8+(B <ishib****@syste*****> wrote: > > > > $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*****
