MySQL Help

23,038 topics in this forum

1. Delete hierarchical parent and child category and update child as parent

   By thara, May 30, 2021   

   • php
   • mysql
   • 8 replies
   • 1.6k views
   • 
   • thara
   • June 6, 2021

2. CONCAT with WHERE clause?

   By ChenXiu, June 4, 2021
   • 8 replies
   • 1k views
   • 
   • ChenXiu
   • June 5, 2021

3. Thank you for being my rubber ducky

   By soycharliente, May 30, 2021
   • 0 replies
   • 605 views
   • 
   • soycharliente
   • May 30, 2021

4. Why wrap mySQL in "if" statement?

   By ChenXiu, May 29, 2021   

   • excessive code
   • 2 replies
   • 764 views
   • 
   • mac_gyver
   • May 29, 2021

5. Mysql query problem with data retrieved

   By gmc1103, May 27, 2021
   • 0 replies
   • 609 views
   • 
   • gmc1103
   • May 27, 2021

6. If key exists, how to concat another column?

   By ChenXiu, May 24, 2021
   • 6 replies
   • 1.2k views
   • 
   • ChenXiu
   • May 25, 2021

7. Unsure why I cannot see the table i'm doing a join on

   By Fishcakes, May 24, 2021
   • 3 replies
   • 649 views
   • 
   • Barand
   • May 24, 2021

8. Query on a list range

   By JohanM, May 21, 2021
   • 4 replies
   • 1.2k views
   • 
   • Barand
   • May 23, 2021

9. Display missing rows from junction table

   By maxasrg, May 22, 2021
   • 5 replies
   • 1.5k views
   • 
   • Barand
   • May 23, 2021

10. Assign my own numbersystem in MySQL DB.

    By LeonLatex, April 11, 2021
    • 15 replies
    • 2k views
    • 
    • LeonLatex
    • April 26, 2021

11. Checking Username Exists

    By Hendz, April 23, 2021
    • 2 replies
    • 849 views
    • 
    • Strider64
    • April 23, 2021

12. Select id that has more than one value in an in clause

    By Adamhumbug, April 20, 2021
    • 4 replies
    • 1.2k views
    • 
    • Adamhumbug
    • April 20, 2021

13. Check consecutive dates in comma seperated string

    By Adamhumbug, April 12, 2021
    • 7 replies
    • 1.9k views
    • 
    • Adamhumbug
    • April 20, 2021

14. why i get multiple results in phpmy admin but only get one result display on my page?

    By sashavalentina, April 19, 2021
    • 4 replies
    • 863 views
    • 
    • Barand
    • April 19, 2021

15. result does not show in tables

    By sashavalentina, April 19, 2021
    • 1 reply
    • 668 views
    • 
    • mac_gyver
    • April 19, 2021

16. Opening SQL DB fails

    By Martn, April 18, 2021
    • 1 reply
    • 578 views
    • 
    • Barand
    • April 18, 2021

17. How do i cross join , Inner join and Group tables

    By sashavalentina, April 18, 2021
    • 1 reply
    • 645 views
    • 
    • Barand
    • April 18, 2021

18. Compare Two MySQL Tables and Update Foreign Key Column With Any Missing IDs

    By mcfc4heatons, April 18, 2021
    • 3 replies
    • 770 views
    • 
    • Barand
    • April 18, 2021

19. MySQL JSON Field Type Indexed Array

    By Heretic86, April 6, 2021
    • 3 replies
    • 1k views
    • 
    • Barand
    • April 7, 2021

20. What are the MSSQL SQL Job analogues?

    By Sunless, April 4, 2021
    • 1 reply
    • 655 views
    • 
    • gizmola
    • April 6, 2021

21. is this possible

    By mahenda, April 4, 2021
    • 1 reply
    • 1.1k views
    • 
    • Barand
    • April 4, 2021

22. Convert various date formats into one

    By Adamhumbug, March 23, 2021
    • 9 replies
    • 2.8k views
    • 
    • Barand
    • March 26, 2021

23. Problem with sub query

    By mongoose00318, March 24, 2021
    • 18 replies
    • 2.5k views
    • 
    • mongoose00318
    • March 24, 2021

24. Help with statement to select row where dates previous to today.

    By Robbiez, March 20, 2021
    • 1 reply
    • 625 views
    • 
    • requinix
    • March 20, 2021

25. Help with a ordering

    By Lazarus99, March 12, 2021
    • 7 replies
    • 1.5k views
    • 
    • Barand
    • March 13, 2021