MySQL Help

23,054 topics in this forum

1. Compare two values in same table

   By budimir, December 15, 2014
   • 4 replies
   • 1.4k views
   • 
   • budimir
   • December 15, 2014

2. IP2Location Database IPv6 conversion to IP Number Decimal

   By brentman, December 15, 2014
   • 9 replies
   • 3.3k views
   • 
   • brentman
   • December 18, 2014

3. Display NULL only

   By kendris, December 13, 2014   

   • sql
   • 1 reply
   • 1.2k views
   • 
   • kendris
   • December 13, 2014

4. Unable to create temp table in proc.

   By Jerms01, December 11, 2014
   • 3 replies
   • 1.2k views
   • 
   • Jerms01
   • December 12, 2014

5. How to add records to query

   By AndyPSV, December 11, 2014
   • 0 replies
   • 1k views
   • 
   • AndyPSV
   • December 11, 2014

6. Duplicate every row of table AND also change one field?

   By galvin, December 11, 2014   

   • mysql
   • 6 replies
   • 1.6k views
   • 
   • CroNiX
   • December 11, 2014

7. How to order by order in other table

   By AndyPSV, December 11, 2014
   • 10 replies
   • 1.9k views
   • 
   • Barand
   • December 11, 2014

8. How to link a column in one table to another table

   By louiscb, December 11, 2014
   • 1 reply
   • 1.2k views
   • 
   • Barand
   • December 11, 2014

9. mysqli prepared statements on tables joined by a common value

   By ajoo, December 11, 2014   

   • mysqli pdo
   • joined tables pdo
   • 4 replies
   • 1.3k views
   • 
   • ajoo
   • December 11, 2014

10. failed transaction upsets the auto increment values

    By ajoo, December 10, 2014   

    • transactions
    • auto increment values
    • 4 replies
    • 2.2k views
    • 
    • ajoo
    • December 11, 2014

11. Filtering by multiple categories in the same row

    By whitt, December 9, 2014   

    • sql
    • filtering
    • 6 replies
    • 1.8k views
    • 
    • Barand
    • December 9, 2014

12. Better way of sorting data

    By whitt, December 8, 2014   

    • mysql
    • sql
    • (and 1 more)

      Tagged with:

      • mysql
      • sql
      • tables
    • 8 replies
    • 2.2k views
    • 
    • kicken
    • December 9, 2014

13. Select distinct entries only

    By SarahBear, December 7, 2014
    • 6 replies
    • 2.2k views
    • 
    • SarahBear
    • December 7, 2014

14. Help with query

    By tobeyt23, December 5, 2014
    • 1 reply
    • 1.2k views
    • 
    • cyberRobot
    • December 16, 2014

15. SQL Join Two Tables

    By johnnys, December 5, 2014
    • 4 replies
    • 1.4k views
    • 
    • Barand
    • December 5, 2014

16. do an UPDATE to 2 tables conditional to field value in one table

    By BuildMyWeb, December 4, 2014
    • 0 replies
    • 1.1k views
    • 
    • BuildMyWeb
    • December 4, 2014

17. db-passwd : port over from server to local machine

    By Maze, December 4, 2014   

    • db-passwd: porting over data
    • 2 replies
    • 1.1k views
    • 
    • gizmola
    • December 4, 2014

18. Basic Help With Join Tables

    By johnnys, December 4, 2014   

    • join
    • mysql
    • (and 1 more)

      Tagged with:

      • join
      • mysql
      • phpmyadmin
    • 4 replies
    • 4k views
    • 
    • Ch0cu3r
    • December 4, 2014

19. help me with update records in mysql database

    By tyrone99, December 4, 2014   

    • mysql
    • 1 reply
    • 1.1k views
    • 
    • cyberRobot
    • December 4, 2014

20. Speed mysql query inside foreach loop

    By pietrofxq, December 3, 2014   

    • mysql
    • select
    • (and 1 more)

      Tagged with:

      • mysql
      • select
      • foreach
    • 4 replies
    • 6.2k views
    • 
    • Psycho
    • December 8, 2014

21. MYSQL Update with maximum value

    By BuildMyWeb, December 3, 2014
    • 4 replies
    • 1.3k views
    • 
    • Barand
    • December 3, 2014

22. SQL SUM() Calculates only one row in sub query

    By MulOnPomm, December 1, 2014   

    • mysql
    • sql
    • (and 2 more)

      Tagged with:

      • mysql
      • sql
      • sum
      • query
    • 0 replies
    • 1.5k views
    • 
    • MulOnPomm
    • December 1, 2014

23. New to load balancing database, which idea is best?

    By brentman, December 1, 2014   

    • load balancing
    • performance
    • (and 3 more)

      Tagged with:

      • load balancing
      • performance
      • speed
      • mysql
      • big table
    • 3 replies
    • 1.5k views
    • 
    • kicken
    • December 2, 2014

24. table not being sorted by primary key by default

    By E_Leeder, November 29, 2014
    • 4 replies
    • 3.4k views
    • 
    • kicken
    • November 30, 2014

25. SQL Select Help

    By Dominik, November 28, 2014
    • 2 replies
    • 1.1k views
    • 
    • Dominik
    • November 28, 2014