#mysql
31 October 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last
23:55 <****> ToeBee, SELECT DISTINCT article_category_id, REPLACE( article_title, ' ', '_' ) FROM article_master
23:55 <****> SHOW VARIABLES LIKE "%innodb%"
23:55 <****> that works
23:56 <****> E-bola: Have fun :)
23:56 <****> how can I add a second replace into that query?
23:56 <****> on the same column? you can nest them
23:56 <****> No, seriously, there are no 'universal truths' about tweaking (well, there are, but big topic), it's so dependant on application, table structure, usage patterns etc
23:56 <****> sensei: will any of the settings effect, the recoverability after a power outage?
23:56 <****> im not really concerned with performance
23:56 <****> hardware is cheaper than my tim
23:56 <****> +e
23:57 <****> Which is why there are companies such as Percona which are dedicated to doing MySQL tweaking alone
23:57 <****> timelf123, you mean replace(replace(a,'a','b'),'c','d') ?
23:57 <****> select ..., replace( replace(article_title, ' ', '_'), 'a','b')
23:57 <****> E-bola: Yeah, buffers and especially the trx commit etc
23:57 <****> thanks :) ill try that now
23:57 <****> binlog buffers is one
23:57 <****> I@m not going in to this topic on IRC tho ;)
23:58 <****> timelf123: you're determined to do this in SQL aren't you?
23:58 <****> is there any command to get the databases from a server
23:58 <****> lol I can't use urlencode afaik because it doesn't make clean URLs
23:58 <****> sensei: fair enough
23:58 <****> ile read up a bit on it
23:58 <****> it encodes some of the chars, but I just want to strip them
23:58 <****> like domain.com/category/article_name_fits_here
23:58 <****> There's quite a few books on teh subject, as well as bits and pieces scattered across the web, just be careful
23:59 <****> instead of domain.com/category/Article Name Fits Here!
23:59 <****> Gotta jet, good luck E-bola
23:59 <****> thank sensei!
23:59 <****> is there any command to get the databases from a server??
23:59 <****> you've been most patient with my lazy self
23:59 <****> fitoria: do you mean remotely?
--- Log closed Thu Nov 01 00:00:05 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last