MySQL Help

23,039 topics in this forum

1. Pulling data from two tables

   By TapeGun007, August 10, 2022
   • 3 replies
   • 672 views
   • 
   • requinix
   • August 10, 2022

2. Selecting from duplicate values but wanting the max

   By mongoose00318, July 8, 2021
   • 11 replies
   • 1.7k views
   • 
   • Barand
   • July 27, 2022

3. Latest MySQL (upgrade Laragon)

   By LeonLatex, July 13, 2022
   • 8 replies
   • 987 views
   • 
   • LeonLatex
   • July 13, 2022

4. create MAX table: include additional column value

   By ChenXiu, July 12, 2022
   • 6 replies
   • 1.3k views
   • 
   • Barand
   • July 12, 2022

5. 1292 Incorrect datetime value - converting to MySQL 8

   By ober, July 10, 2022
   • 4 replies
   • 3k views
   • 
   • ober
   • July 10, 2022

6. mysql error statements not working

   By ayoubel12, July 7, 2022
   • 1 reply
   • 733 views
   • 
   • Barand
   • July 7, 2022

7. How do you list two columns but not show duplicates from first column?

   By Plugnz13, June 21, 2022
   • 3 replies
   • 1.2k views
   • 
   • Plugnz13
   • June 24, 2022

8. Custom query for count if against three tables...

   By chadrt, June 24, 2022
   • 1 reply
   • 1.1k views
   • 
   • mac_gyver
   • June 24, 2022

9. Using Max not giving the data i expect

   By Adamhumbug, June 21, 2022
   • 8 replies
   • 1.2k views
   • 
   • mac_gyver
   • June 23, 2022

10. MySQL after update trigger with number of affected rows condition

    By thara, June 21, 2022   

    • mysql
    • sql
    • (and 1 more)

      Tagged with:

      • mysql
      • sql
      • trigger
    • 1 reply
    • 819 views
    • 
    • requinix
    • June 21, 2022

11. Error insertuserquery

    By Pikatucy, June 16, 2022
    • 18 replies
    • 1.8k views
    • 
    • Pikatucy
    • June 19, 2022

12. Foreign key NOT working

    By phppup, June 1, 2022
    • 9 replies
    • 1.5k views
    • 
    • phppup
    • June 12, 2022

13. Objects, Classes, Variables, Libraries and Functions

    By LeonLatex, June 9, 2022
    • 8 replies
    • 1.5k views
    • 
    • mac_gyver
    • June 10, 2022

14. Pivot Table or Cross Tab in PHP using MYSQLI for attendance

    By Zinn, June 6, 2022   

    • php
    • mysqli
    • (and 3 more)

      Tagged with:

      • php
      • mysqli
      • pivot table
      • table
      • date
    • 15 replies
    • 2.2k views
    • 
    • Zinn
    • June 9, 2022

15. Error in a PHP MySQL CMS.

    By LeonLatex, June 8, 2022
    • 13 replies
    • 1.4k views
    • 
    • LeonLatex
    • June 9, 2022

16. MySQL update query to automatically Deduct quantity sold from quantity in the stock table 1 2

    By thara, June 4, 2022   

    • mysql
    • sql
    • 25 replies
    • 2.7k views
    • 
    • thara
    • June 8, 2022

17. Which is faster, MySql INNER JOIN or PHP Loop?

    By SLSCoder, May 19, 2022
    • 8 replies
    • 2.2k views
    • 
    • SLSCoder
    • June 7, 2022

18. How can I make this more efficient?

    By SLSCoder, June 6, 2022
    • 0 replies
    • 536 views
    • 
    • SLSCoder
    • June 6, 2022

19. Can't CREATE DATABASE and more problems with Laragon and MySQL

    By LeonLatex, June 5, 2022
    • 10 replies
    • 4.1k views
    • 
    • LeonLatex
    • June 5, 2022

20. Laragon 8.0.29 set password on root

    By LeonLatex, June 2, 2022
    • 7 replies
    • 2.3k views
    • 
    • LeonLatex
    • June 2, 2022

21. Download MySQL 8.0.29

    By LeonLatex, May 31, 2022
    • 5 replies
    • 1.6k views
    • 
    • LeonLatex
    • June 1, 2022

22. Getting unique rows

    By ginerjm, May 25, 2022
    • 14 replies
    • 1.2k views
    • 
    • Barand
    • May 26, 2022

23. Another database structure

    By phppup, May 24, 2022
    • 6 replies
    • 1.3k views
    • 
    • Barand
    • May 24, 2022

24. Understanding mySQL dates and times.

    By TapeGun007, May 22, 2022
    • 5 replies
    • 663 views
    • 
    • TapeGun007
    • May 23, 2022

25. Setting up foreign key

    By phppup, May 22, 2022
    • 5 replies
    • 731 views
    • 
    • Barand
    • May 22, 2022