Hi Craig and others,
On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn wrote:
> blue.trapez...@gmail.com wrote:
>
>> Hi
>>
>> I have 2 servers and I am trying to set up (for testing purposes) a
>> master-master replication environment. I read the instructions in the
>> manual
>> for master-slave, but
Hi Seth,
I implemented SSL successfully just a couple of weeks ago on 5.1.30, and
I too found some aspects confusing. Here's my answers from my own
experience so please forgive me if they're inaccurate.
1) On the server side, I believe ssl-ca, ssl-cert and ssl-key are all
required to establ
An explain of the two statements yields the same plan,
anybody knows if they are actually translated in the same plan?
Claudio
Ian P. Christian wrote:
2009/3/29 Oscar :
Hi all-
I want to know what the difference between IN and OR is under the hood.
select * from dummy_table where id in (2
basically the same criteria as IN vs EXISTS from
http://decipherinfosys.wordpress.com/2007/01/30/in-vs-exists/
select from TABLE_A where col1 in (Select col2 from
TABLE_B)
VS
Select from TABLE_A where exists (select 1 from Table_B
where Table_B.col2 =
An approach that has worked for me in the past and may work for you. Declare
as many parms as you can possibly need and then code the statement like
this:
SELECT * FROM someWhere
WHERE @parm1 = 123 OR @parm1 IS NULL
AND @parm2 = 345 OR @parm2 IS NULL
-- etc.
This has the desired effect and elimi
2009/3/29 Oscar :
> Hi all-
>
> I want to know what the difference between IN and OR is under the hood.
>
> select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
>
> select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
> id=7;
I've have thought once the query is compiled, th
Hi All, I am trying to find the top 5 ee_entry id's, and then return
all rows matching any of the 5 ee_entry id's. I think I am close, but
the following sql is currently only returning rows matching the first
ee_entry in the group_concat. If I run the subquery separately and
manually create the s
