MySQL Help

23,052 topics in this forum

1. Ordering by a specific value without using a filesort.

   By mattal999, September 25, 2011
   • 5 replies
   • 840 views
   • 
   • fenway
   • September 27, 2011

2. One to Many Join

   By sniperscope, September 27, 2011
   • 5 replies
   • 681 views
   • 
   • fenway
   • September 27, 2011

3. MOVED: mail from problems

   By fenway, September 27, 2011
   • 0 replies
   • 549 views
   • 
   • fenway
   • September 27, 2011

4. INNODB fragmentation, unable to defragment...

   By menntarra_34, September 23, 2011
   • 6 replies
   • 3.1k views
   • 
   • fenway
   • September 27, 2011

5. Can select with any field but email

   By Pierre-André, September 27, 2011
   • 2 replies
   • 524 views
   • 
   • Pierre-André
   • September 27, 2011

6. PDOExcepction

   By omidh, September 27, 2011
   • 3 replies
   • 935 views
   • 
   • awjudd
   • September 27, 2011

7. PDOExcepction

   By omidh, September 27, 2011
   • 0 replies
   • 1k views
   • 
   • omidh
   • September 27, 2011

8. Select a random row with GROUP BY

   By aspacecodyssey, September 26, 2011
   • 3 replies
   • 6.3k views
   • 
   • aspacecodyssey
   • September 27, 2011

9. Filter inappropriate search results

   By phpsycho, September 26, 2011
   • 6 replies
   • 1.1k views
   • 
   • phpsycho
   • September 27, 2011

10. MOVED: Need sql file for test

    By Pikachu2000, September 27, 2011
    • 0 replies
    • 491 views
    • 
    • Pikachu2000
    • September 27, 2011

11. how to select Random with order by

    By hno, September 24, 2011
    • 6 replies
    • 836 views
    • 
    • fenway
    • September 26, 2011

12. Mage a table without getting the duplicates... and anothers functions.

    By angeloghiotto, September 20, 2011
    • 3 replies
    • 1k views
    • 
    • fenway
    • September 26, 2011

13. Converting a value (price) within a mysql query. Is this possble?

    By simboski19, September 19, 2011
    • 6 replies
    • 6.6k views
    • 
    • simboski19
    • September 26, 2011

14. MOVED: need help to implement preg_replace in my import script

    By fenway, September 25, 2011
    • 0 replies
    • 550 views
    • 
    • fenway
    • September 25, 2011

15. Can't find what's wrong with this SQL syntax

    By Nethox, September 25, 2011
    • 2 replies
    • 540 views
    • 
    • Nethox
    • September 25, 2011

16. ORDER BY AVG and COUNT

    By iceblox, September 24, 2011
    • 2 replies
    • 633 views
    • 
    • iceblox
    • September 24, 2011

17. order by top auction then by date

    By UnknownPlayer, September 24, 2011
    • 2 replies
    • 709 views
    • 
    • fenway
    • September 24, 2011

18. need help querying multiple tables

    By shanetastic, September 24, 2011
    • 2 replies
    • 533 views
    • 
    • shanetastic
    • September 24, 2011

19. ORDER data by total number of rows?

    By EchoFool, September 23, 2011
    • 3 replies
    • 568 views
    • 
    • Maq
    • September 23, 2011

20. Creating indes makes no difference in SELECT statement

    By MockY, September 23, 2011
    • 1 reply
    • 870 views
    • 
    • fenway
    • September 23, 2011

21. Basic Update New to PHP MySql

    By junk4u, September 22, 2011
    • 7 replies
    • 1k views
    • 
    • junk4u
    • September 23, 2011

22. JOIN 3 tables, only able to get 2 working.

    By MasterACE14, September 22, 2011
    • 4 replies
    • 730 views
    • 
    • MasterACE14
    • September 23, 2011

23. UPDATE distinct with ID

    By dflow, September 22, 2011
    • 9 replies
    • 3.3k views
    • 
    • requinix
    • September 22, 2011

24. A way to add rows to a table for each file in a folder?

    By membot, September 17, 2011
    • 5 replies
    • 1.2k views
    • 
    • membot
    • September 22, 2011

25. create foreign key within phpmyadmin

    By raptor30506090, September 21, 2011
    • 7 replies
    • 1.9k views
    • 
    • fenway
    • September 22, 2011