From last few days I am struggling to achieve this. For some reason, we need to change the Foreground (display) color of animated gif images...
Hello, I found Google Transliteration, a very good tool to reproduce the sounds of a sentence in a different language. Reference:...
It still really takes 16seconds to Group 90000 rows if i remove MAX, MIN, COUNT and ORDER BY. May be i need to change something with the INDEX...
How to speed up the Group By Clause for a large 3GB database. I am using Group by clause for a large database having 148 columns and 5...
Hi all, First of all I am new with server using. Below my virtual private server details: Processor : 2.8 GHz Dual Core Processor Cores: 2...
I have a table with 4 columns Table name = products Column name = product_id, product_programname, product_title, model_number When I use...
Great and Thank you.
Thats great. Thanks a lot. I just made a small change in query: UPDATE elec_products SET stats = CASE programmename WHEN 'Argos' THEN 1 WHEN...
How to fetch the "name" FROM programname = "Buy" and description which has maximum words using GROUP BY?? I have 6 columns with thousands of...
Separate names with a comma.
