Re: [OT] Suggestion of query manager

2009-10-13 Thread Michael Dykman
http://dev.mysql.com/downloads/gui-tools/5.0.html On Mon, Oct 12, 2009 at 7:23 PM, Marcelo de Assis saloma...@gmail.com wrote: Hi people! Can anyone suggest a query manager on linux environment - like Heidisql? I using MySQL Navigator:

Re: [OT] Suggestion of query manager

2009-10-13 Thread Walter Heck - OlinData.com
The GUI tools are horrible, and I probably wouldn't recommend them to my worst enemy :) Take a look at workbench. It is getting better with every release, especially now that they added SSH tunneling into it. It is still beta-status though, but it might work for you:

OR vs UNION

2009-10-13 Thread Majk.Skoric
Hi List, i have a problem with an OR STATEMENT. Maybe someone can explain to me why the mysql optimizer doesn't work like expected. Please have a look at following similar queries. mysql explain SELECT * FROM KTEMP WHERE (buchungs_kunde_id = 'dfb49c8c0b441e9f' and veranst_id = 16058 and status =

Re: OR vs UNION

2009-10-13 Thread Joerg Bruehe
Majk, all, I'm no optimizer expert, but your result doesn't really surprise me. I'll reorder your post because that makes reasoning simpler: majk.sko...@eventim.de wrote: Hi List, First, your table: TABLEDEF. | KTEMP | CREATE TABLE `KTEMP` ( `tid` bigint(20) NOT NULL auto_increment,

AW: OR vs UNION

2009-10-13 Thread Majk.Skoric
-Ursprüngliche Nachricht- Von: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Gesendet: Dienstag, 13. Oktober 2009 15:26 An: Skoric, Majk Cc: mysql@lists.mysql.com Betreff: Re: OR vs UNION Majk, all, I'm no optimizer expert, but your result doesn't really surprise me.

escape quotes

2009-10-13 Thread Lex Thoonen
Hi, I'm trying to replace this: h2 style=margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px; font-size: 30px; color: #b4b4be; but UPDATE `jos_content` SET `introtext` = replace(`introtext`,h2 style=\margin: 0px 0px