#mysql
06 November 2007
Total 30 pages. You are browsing page 30/30.
First :: Prev :: [...] [26] [27] [28] [29] [30] :: Next :: Last
23:26 <****> !tell DaPoohba about a not in b
23:27 <****> Alrighty.
23:27 <****> new2php: pastebin coe
23:27 <****> code*
23:28 <****> chadmaynard http://pastebin.com/d12d9ab98
23:29 <****> new2php: do you get error?
23:30 <****> chadmaynard: nope. output of that code shows: Cr / Co / Cu / Fe /5264PE which is item name: Cr / Co / Cu / Fe / and itemid 5264PE
23:31 <****> new2php: i think the itemname needs to be escaper
23:32 <****> chadmaynard: eh?
23:34 <****> new2php: are you displaying this with a web browser?
23:34 <****> chadmaynard yes
23:40 <****> Are there any simple gotchas when creating a full text index? I followed the manual's little tutorial and it worked, however I have another table with almost the same layout, and I am not getting matches agains words I know are there and are not blacklisted.
23:41 <****> what does explain say?
23:42 <****> It's using the correct index, type is fulltext, key_len is 0, rows is 1(there should be two results), extra - using where
23:48 <****> Anveo: word length restrictions? word frequency restrictions?
23:48 <****> ft_min is 4, max is 84
23:49 <****> Where would I look for freqency restrictions?
23:49 <****> 50% of rows, it will not be returned.
23:50 <****> hello
23:51 <****> i'm trying to optimize a query, details at: http://rafb.net/p/UN0m5g29.html
23:51 <****> hello
23:51 <****> how to make a LIKE sentence with variables in a procedure ?
23:52 <****> ki77a77: That's probably it, I will add more data. This is just for quick testing before we move to Sphinx. Thanks!
23:52 <****> example: create procedure proc(val varchar(50)) ... WHERE this LIKE '%val%' ...
23:52 <****> i dunno how to tell mysql to substitute
23:52 <****> Anveo: that very often happens during development.
23:53 <****> fosco: !"#$@ !
23:53 <****> is a big int a 32 bit number
23:53 <****> like the max that 32 bit can go?
23:54 <****> PaulB: much bigger than that. http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
23:59 <****> i'm trying to optimize a query, details at: http://rafb.net/p/UN0m5g29.html
23:59 <****> can anyone help me?
23:59 <****> the query is taking 12 seconds
--- Log closed Wed Nov 07 00:00:22 2007
Total 30 pages. You are browsing page 30/30.
First :: Prev :: [...] [26] [27] [28] [29] [30] :: Next :: Last