MySQL Help

22,761 topics in this forum

1. How would you use SUM twice in a single query from two separate tables?

   By imgrooot, May 5, 2018
   • 8 replies
   • 719 views
   • 
   • imgrooot
   • May 11, 2018

2. How to SUM action from all users one by one?

   By Terminaxx, April 4, 2018
   • 7 replies
   • 858 views
   • 
   • Terminaxx
   • April 4, 2018

3. summing 2 columns data in single table with different condition

   By dishadcruze, February 17, 2018
   • 6 replies
   • 664 views
   • 
   • dishadcruze
   • February 19, 2018

4. Latest Conversations

   By mentalist, February 14, 2018
   • 7 replies
   • 832 views
   • 
   • mentalist
   • February 15, 2018

5. Database Schema

   By glendango, February 14, 2018   

   • mysql php
   • 2 replies
   • 485 views
   • 
   • glendango
   • February 14, 2018

6. Issue with inserting data into database #2

   By phreak3r, January 18, 2018
   • 18 replies
   • 667 views
   • 
   • phreak3r
   • January 19, 2018

7. ON DUPLICATE KEY UPDATE - Positional Placeholders

   By benanamen, January 18, 2018
   • 1 reply
   • 669 views
   • 
   • benanamen
   • January 18, 2018

8. linearize relationship

   By ajoo, January 17, 2018   

   • mysql
   • 6 replies
   • 499 views
   • 
   • ajoo
   • January 17, 2018

9. A really weird update problem

   By Rommeo, January 16, 2018
   • 2 replies
   • 498 views
   • 
   • Rommeo
   • January 16, 2018

10. changing the database for a different country.

    By ajoo, January 9, 2018   

    • database
    • dynamic databases
    • 5 replies
    • 558 views
    • 
    • requinix
    • January 9, 2018

11. another table to the query

    By ajoo, December 31, 2017   

    • mysql
    • multi table
    • 4 replies
    • 484 views
    • 
    • ajoo
    • January 1, 2018

12. newbie getting unexpected $end

    By sdgsdghshhg, November 15, 2017
    • 8 replies
    • 501 views
    • 
    • sdgsdghshhg
    • November 16, 2017

13. Recover DB after HDD crash

    By phdphd, November 13, 2017
    • 7 replies
    • 509 views
    • 
    • phdphd
    • November 14, 2017

14. display user even if select query returns nothing

    By glendango, October 18, 2017
    • 16 replies
    • 664 views
    • 
    • Barand
    • October 25, 2017

15. INSERT ON DUPLICATE KEY

    By loki951510, October 21, 2017   

    • insert
    • on duplicate
    • 3 replies
    • 513 views
    • 
    • loki951510
    • October 22, 2017

16. MySql Loop through a column to form concatenated string

    By shades, July 22, 2017
    • 4 replies
    • 770 views
    • 
    • requinix
    • October 16, 2017

17. Another Triggers question...

    By Jim R, September 5, 2017
    • 8 replies
    • 467 views
    • 
    • Jim R
    • September 6, 2017

18. Dealing with Triggers...

    By Jim R, September 5, 2017   

    • triggers
    • 12 replies
    • 394 views
    • 
    • Jim R
    • September 5, 2017

19. Prepare statement query not executing

    By shades, September 1, 2017   

    • php
    • pdo
    • (and 1 more)

      Tagged with:

      • php
      • pdo
      • mysql
    • 3 replies
    • 550 views
    • 
    • shades
    • September 2, 2017

20. create table; datetime default value current_timestamp +

    By fatkatie, August 24, 2017   

    • mysql
    • 5 replies
    • 636 views
    • 
    • Jacques1
    • August 27, 2017

21. Join table and get only one row from other table

    By LLLLLLL, August 18, 2017   

    • sql
    • join
    • (and 1 more)

      Tagged with:

      • sql
      • join
      • one
    • 5 replies
    • 484 views
    • 
    • Psycho
    • August 24, 2017

22. summing using dynamic sql

    By shaddf, August 16, 2017   

    • mysql
    • 5 replies
    • 516 views
    • 
    • requinix
    • August 16, 2017

23. calculation in a query

    By shaddf, August 8, 2017   

    • mysql
    • 6 replies
    • 683 views
    • 
    • Psycho
    • August 14, 2017

24. Using upsert with multiple unique index/columns

    By thenorman138, August 9, 2017   

    • sql
    • mysql
    • (and 2 more)

      Tagged with:

      • sql
      • mysql
      • upsert
      • unique
    • 13 replies
    • 742 views
    • 
    • Barand
    • August 10, 2017

25. Best way to do this...

    By avgjoe_007, August 9, 2017
    • 3 replies
    • 434 views
    • 
    • avgjoe_007
    • August 10, 2017