MySQL Help

23,006 topics in this forum

1. Query about how to retrieve a password from the database and compare to the one the user has entered 1 2 3

   By Paul_Withers, September 4, 2014
   • 56 replies
   • 7.6k views
   • 
   • jazzman1
   • September 9, 2014

2. Copy all records with 2 equals data from table1 to one record in table2 (second part) 1 2 3

   By paolo123, May 11, 2015
   • 54 replies
   • 4.2k views
   • 
   • Barand
   • May 14, 2015

3. New SQL creation problem 1 2

   By Erwin007, May 15, 2023
   • 49 replies
   • 1.8k views
   • 
   • mac_gyver
   • May 26, 2023

4. WEEKLY QUERY 1 2

   By benanamen, January 7, 2016   

   • mysql
   • 38 replies
   • 2.9k views
   • 
   • benanamen
   • January 12, 2016

5. SQL help for extracting common details 1 2

   By webdev1, September 2, 2013
   • 32 replies
   • 1.7k views
   • 
   • webdev1
   • September 5, 2013

6. mutliple conditions for same join for same column 1 2

   By Destramic, December 28, 2015
   • 29 replies
   • 2.3k views
   • 
   • Destramic
   • December 31, 2015

7. Inner join... 1 2

   By arunpatal, November 27, 2013
   • 29 replies
   • 3.4k views
   • 
   • arunpatal
   • November 28, 2013

8. update multiple tables 1 query 1 2

   By patchido, May 7, 2013   

   • sql php query
   • 27 replies
   • 2.3k views
   • 
   • Barand
   • May 12, 2013

9. A data structure problem ! 1 2

   By ajoo, June 30, 2016   

   • hierarchical relations in mys
   • 26 replies
   • 2.3k views
   • 
   • ajoo
   • July 7, 2016

10. CSV Export query with date range 1 2

    By 83Lee83, May 13, 2013   

    • php
    • mysql
    • (and 2 more)

      Tagged with:

      • php
      • mysql
      • database query
      • date range
    • 26 replies
    • 6.8k views
    • 
    • 83Lee83
    • May 17, 2013

11. 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
    • 1.7k views
    • 
    • thara
    • June 8, 2022

12. SELECT DISTINCT not working to what i want

    By cainam29, May 3, 2013   

    • sql
    • 23 replies
    • 4.3k views
    • 
    • cainam29
    • May 5, 2013

13. phpmyadmin blob insert error

    By Q695, March 3, 2014   

    • video
    • blob
    • (and 1 more)

      Tagged with:

      • video
      • blob
      • phpmyadmin
    • 23 replies
    • 8.6k views
    • 
    • Q695
    • March 12, 2014

14. Associating cinema times with Screen numbers

    By webdeveloper123, January 24
    • 22 replies
    • 580 views
    • 
    • Barand
    • February 8

15. Create two user_type tables from a user table

    By k2sno311, April 24, 2013   

    • create_table
    • 22 replies
    • 1.9k views
    • 
    • k2sno311
    • April 29, 2013

16. Using row_number on attribute to only return 5 rows

    By webdeveloper123, September 21, 2023
    • 21 replies
    • 859 views
    • 
    • webdeveloper123
    • September 25, 2023

17. Left Join values from non-existing table to a real one

    By jazzman1, February 1, 2014
    • 21 replies
    • 1.4k views
    • 
    • jazzman1
    • February 1, 2014

18. Turning an array into a column

    By EricOnAdventure, June 16, 2016
    • 20 replies
    • 2.2k views
    • 
    • Muddy_Funster
    • June 19, 2016

19. Copy all records with 2 equals data from table1 to one record in table2

    By paolo123, May 5, 2015
    • 20 replies
    • 2.1k views
    • 
    • paolo123
    • May 11, 2015

20. mysql event last executed time incorrect by 6 hours

    By kathygriffin, March 5, 2014
    • 19 replies
    • 2.2k views
    • 
    • kathygriffin
    • March 10, 2014

21. NOT EXISTS, RAND(), and JOIN

    By Q695, May 30, 2013   

    • not exists
    • rand()
    • (and 1 more)

      Tagged with:

      • not exists
      • rand()
      • join
    • 19 replies
    • 1.6k views
    • 
    • Barand
    • June 9, 2013

22. UPDATE multicolumns in TABLE

    By PriteshP23, August 9, 2013   

    • update
    • sql
    • (and 1 more)

      Tagged with:

      • update
      • sql
      • database
    • 19 replies
    • 1.5k views
    • 
    • mikosiko
    • August 13, 2013

23. Union Select

    By Adamhumbug, October 19, 2023
    • 19 replies
    • 714 views
    • 
    • Adamhumbug
    • October 21, 2023

24. Problem with sub query

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

25. Issue with inserting data into database #2

    By phreak3r, January 18, 2018
    • 18 replies
    • 2.3k views
    • 
    • phreak3r
    • January 19, 2018