COMPUTER SCIENCE CAFÉ
  • WORKBOOKS
  • BLOCKY GAMES
  • GCSE
    • CAMBRIDGE GCSE
  • IB
  • A LEVEL
  • LEARN TO CODE
  • ROBOTICS ENGINEERING
  • MORE
    • CLASS PROJECTS
    • Classroom Discussions
    • Useful Links
    • SUBSCRIBE
    • ABOUT US
    • CONTACT US
    • PRIVACY POLICY
  • WORKBOOKS
  • BLOCKY GAMES
  • GCSE
    • CAMBRIDGE GCSE
  • IB
  • A LEVEL
  • LEARN TO CODE
  • ROBOTICS ENGINEERING
  • MORE
    • CLASS PROJECTS
    • Classroom Discussions
    • Useful Links
    • SUBSCRIBE
    • ABOUT US
    • CONTACT US
    • PRIVACY POLICY
FUN WITH CODING
SQL QUICK REFERENCE
IN THIS SECTION
This section cover some of the most popular methods of manipulating, storing and accessing data from a database.  Most examples are give using SQLite however the principles apply to SQL with MySQL, SQL Server, MS Access and more.
​SQL SELECTION METHODS
SELECT ALL
SELECT DISTINCT
SELECT WHERE
SELECT WHERE, AND, OR, NOT
SELECT MIN AND MAX
SELECT WHERE LIKE and wildcards
select between
SQL INSERT METHOD
SQL UPDATE METHODS
SQL DELETE METHOD
SQL CREATING A DATABASE
SUGGESTIONS
We would love to hear from you
SUBSCRIBE 
To enjoy more benefits
We hope you find this site useful. If you notice any errors or would like to contribute material then please contact us.