Hi Afan,
You should do an explain on both of your queries and check for the following
parameters:
1. How many rows are being checked for your query?
2. What all indexes are being used?
3. What are the extra steps in query execution?
Otherwise IMHO, the first query with a union is any day better t
The two querys's logic are different.Which is you need?
- Original Message -
From: "afan pasalic" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 04, 2008 5:50 AM
Subject: what's better query?
> Hi,
>
> I have two tables, "people" and "membership". Both have email column
> (different co
Hi Krishna
Just do the flush logs and check the last binlogs with the mysqlbinlog
xxx-bin > textfile.
Thanks & Regards,
Dilipkumar
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2008 11:11 AM
To: mysql
Subject: mysqlbinlog
Hi
Hi All,
When I am trying to open the current binlog file. Its giving that binlog was
not closed properly. (Please see the bold line) Does it mean that active
binlog can only be opened by stopping mysql server. Is there any other way
to open the current binlog file.
[EMAIL PROTECTED] ~]$mysqlbinlo
