Thank you very much Jorn. Your suggestion helped me.
Hi Fello MySQL users,
I am Bala Raju, i have a problem to extract data by writing query, i need u
r help. Please help me.
I have two tables, i am giving the tables as attachement, firs table is
playersloginfo and second one is playerhanddetails.
playersloginfo : This table stores all the
On Saturday 10 February 2007 12:45, balaraju mandala wrote:
Hi Fello MySQL users,
I am Bala Raju, i have a problem to extract data by writing query, i need u
r help. Please help me.
I have two tables, i am giving the tables as attachement, firs table is
playersloginfo and second one is
Hi Jorn,
Thank you for reply, of course i can merge the columns and change the
datatype. But buddy that is not problem here, the problem is extract the
data.
Did u able to understand my language, if not i will explain you again.
Please read the mail again and tell some ways from u r experience.
On Saturday 10 February 2007 19:21, balaraju mandala wrote:
Hi Jorn,
Thank you for reply, of course i can merge the columns and change the
datatype. But buddy that is not problem here, the problem is extract the
data.
After reading your message once more, I realise that you should do even
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Have you considered splitting this into two queries? One query can gather
information from your token and token_ins tables. The other would join the
first queries results to the other tables to complete your original query.
Depending
Hum,
Well, I'm back with another one... When adding a
join to the previous query, it sloows down once again
even though it retrieves less datat. Here's the info :
mysql explain SELECT ti.posi, ti.docid, d.filename,
ti.id, c.name
FROM corpus_documents cd, corpus c, documents d,
tokens_ins ti,
Have you considered splitting this into two queries? One query can gather
information from your token and token_ins tables. The other would join the
first queries results to the other tables to complete your original query.
Depending on your data, one of these subqueries should return a smaller