MySQL Help

23,042 topics in this forum

1. Query time taking too long and using too much cpu.. How can I optimise this?

   By lynxus, February 9, 2011
   • 2 replies
   • 753 views
   • 
   • fenway
   • February 13, 2011

2. SUM broke query

   By unemployment, February 8, 2011
   • 2 replies
   • 625 views
   • 
   • fenway
   • February 13, 2011

3. Listing recipents with groups

   By tomaszko, February 8, 2011
   • 1 reply
   • 529 views
   • 
   • fenway
   • February 13, 2011

4. CSV Import

   By binarylime, February 4, 2011
   • 2 replies
   • 673 views
   • 
   • fenway
   • February 13, 2011

5. Date search query

   By lunartbh99, February 7, 2011
   • 1 reply
   • 595 views
   • 
   • fenway
   • February 13, 2011

6. select query with random order, limit #, but with specific 1st item if found

   By dsdsdsdsd, February 5, 2011
   • 3 replies
   • 1k views
   • 
   • fenway
   • February 13, 2011

7. Why have I had to change this query after upgrading to MySQL5?

   By MargateSteve, February 6, 2011
   • 2 replies
   • 699 views
   • 
   • fenway
   • February 13, 2011

8. Subtract Value From two tables

   By datoshway, February 5, 2011
   • 2 replies
   • 1.7k views
   • 
   • fenway
   • February 13, 2011

9. Large PHP Array Database Management

   By drath, February 4, 2011
   • 1 reply
   • 872 views
   • 
   • fenway
   • February 13, 2011

10. Setting the default value for max_join_size

    By adrianTNT, February 4, 2011
    • 1 reply
    • 2.4k views
    • 
    • fenway
    • February 13, 2011

11. How to make the "+1" in "'$id'+1" go back to lowest id when $id is highest one?

    By thighmister, February 3, 2011
    • 3 replies
    • 761 views
    • 
    • fenway
    • February 13, 2011

12. select where first character of field is not a letter

    By scarhand, February 1, 2011
    • 6 replies
    • 1.7k views
    • 
    • fenway
    • February 13, 2011

13. DESC sorting by DateH

    By Markota, February 1, 2011
    • 3 replies
    • 874 views
    • 
    • fenway
    • February 13, 2011

14. How do I test and view the results after executing a SQL command?

    By genzedu777, February 13, 2011
    • 1 reply
    • 598 views
    • 
    • trq
    • February 13, 2011

15. regexp replace

    By The Little Guy, February 12, 2011
    • 2 replies
    • 707 views
    • 
    • The Little Guy
    • February 13, 2011

16. Help with a LEFT JOIN pulling different users

    By coupe-r, February 12, 2011
    • 6 replies
    • 769 views
    • 
    • coupe-r
    • February 12, 2011

17. report of queries?

    By freelance84, February 12, 2011
    • 2 replies
    • 451 views
    • 
    • freelance84
    • February 12, 2011

18. MOVED: mysqli help

    By trq, February 12, 2011
    • 0 replies
    • 475 views
    • 
    • trq
    • February 12, 2011

19. MOVED: sql or php problem

    By Pikachu2000, February 12, 2011
    • 0 replies
    • 481 views
    • 
    • Pikachu2000
    • February 12, 2011

20. adding a category to this php page...

    By louroberto, February 10, 2011
    • 2 replies
    • 525 views
    • 
    • gizmola
    • February 11, 2011

21. howto - left join on a column name?

    By ryel01, January 28, 2011
    • 3 replies
    • 760 views
    • 
    • gizmola
    • February 11, 2011

22. Disable error reporting ?

    By Rommeo, February 11, 2011
    • 3 replies
    • 2.6k views
    • 
    • gizmola
    • February 11, 2011

23. Search numbers

    By dreamwest, January 28, 2011
    • 10 replies
    • 1.6k views
    • 
    • Mr Hyde
    • February 11, 2011

24. to retrieve data using joining

    By gulamansari, January 31, 2011
    • 3 replies
    • 1.4k views
    • 
    • fenway
    • February 11, 2011

25. Query help: Second best in each group?

    By Infinitive, January 31, 2011
    • 1 reply
    • 668 views
    • 
    • fenway
    • February 11, 2011