SQL

2,976 topics in this forum

1. SQL Tutorial and Reference

   By kaijim, September 28, 2005
   • 3 replies
   • 81.3k views
   • 
   • warend2
   • December 4, 2013

2. UPDATE with SELECT and GROUP_CONCAT

   By tim79, May 28
   • 0 replies
   • 571 views
   • 
   • tim79
   • May 28

3. STRPOS not working per W3S documentation

   By mickeymouse, February 16
   • 1 reply
   • 546 views
   • 
   • Ingolme
   • February 16

4. Delete not working

   By mickeymouse, February 13
   • 1 reply
   • 250 views
   • 
   • mickeymouse
   • February 13

5. Error in mySQL editor on W3school site, is it just me?

   By KYC, January 21
   • 1 reply
   • 417 views
   • 
   • phpuserlogin
   • February 3

6. PHP vs sqlite3 login error

   By Chikwado, January 8
   • 0 replies
   • 391 views
   • 
   • Chikwado
   • January 8

7. How do you select the first row of a table?

   By gregaryb, August 1, 2022
   • 2 replies
   • 764 views
   • 
   • Chikwado
   • January 4

8. The SQL TryIt Editor no longer works for write operations on Chrome or Edge.

   By John McGarvey, November 12, 2023
   • 1 reply
   • 1k views
   • 
   • JayLearns
   • November 21, 2023

9. Subquery to get value from one table based on another table

   By ShadowMage, November 3, 2023
   • 0 replies
   • 493 views
   • 
   • ShadowMage
   • November 3, 2023

10. How do you include ' character in the column data an INSERT SQL query string?

    By gregaryb, October 31, 2023
    • 0 replies
    • 360 views
    • 
    • gregaryb
    • October 31, 2023

11. WebSQL on iPhone iOS 15 or 16?

    By tbubah, September 25, 2023
    • 0 replies
    • 555 views
    • 
    • tbubah
    • September 25, 2023

12. Select from a menu a listing from a database?

    By phpuserlogin, June 1, 2023
    • 4 replies
    • 860 views
    • 
    • phpuserlogin
    • August 22, 2023

13. I don't understand this correlated subquery

    By david1972, November 23, 2022
    • 0 replies
    • 1.3k views
    • 
    • david1972
    • November 23, 2022

14. Order Value per Region

    By yrstruly, November 3, 2022
    • 0 replies
    • 817 views
    • 
    • yrstruly
    • November 3, 2022

15. Cannot update. Database or object is read-only.

    By Dimos, October 2, 2022
    • 0 replies
    • 779 views
    • 
    • Dimos
    • October 2, 2022

16. Structure of a database with shared items

    By Arbu, August 3, 2022
    • 0 replies
    • 970 views
    • 
    • Arbu
    • August 3, 2022

17. Missing Data(finding the root problem)

    By yrstruly, August 1, 2022
    • 0 replies
    • 648 views
    • 
    • yrstruly
    • August 1, 2022

18. Erro 1146

    By mostafa_dadgar, July 5, 2022
    • 0 replies
    • 732 views
    • 
    • mostafa_dadgar
    • July 5, 2022

19. What does these codelines mean?

    By rootKID, May 26, 2022
    • 0 replies
    • 835 views
    • 
    • rootKID
    • May 26, 2022

20. Help with Mysql and PHP

    By Matthew Payton, May 12, 2022
    • 0 replies
    • 796 views
    • 
    • Matthew Payton
    • May 12, 2022

21. Deleting duplicates after joining two tables

    By Ashu96, February 9, 2022   

    • self join
    • delete
    • (and 1 more)

      Tagged with:

      • self join
      • delete
      • duplicates
    • 3 replies
    • 2.2k views
    • 
    • Ashu96
    • February 12, 2022

22. Seeking help to write a basic query

    By koralt, January 23, 2022
    • 0 replies
    • 894 views
    • 
    • koralt
    • January 23, 2022

23. sql Create $_SESSION vars from a SQL database table ie. $_SESSION[table_column_name] = table_column_1_row_value for any database table

    By Ralph, December 16, 2021   

    • column name
    • column value
    • 0 replies
    • 863 views
    • 
    • Ralph
    • December 16, 2021

24. Use of not with select statement

    By Bishal Chapagain, December 4, 2021
    • 2 replies
    • 865 views
    • 
    • niche
    • December 4, 2021

25. Create SP to Import JSON

    By David Craven, November 23, 2021   

    • sql
    • 1 reply
    • 993 views
    • 
    • David Craven
    • November 23, 2021