Structured Query Language (SQL)

• The SELECT query is used to find and display certain records within the database.
• The UPDATE query is used to change existing values of fields in a record.

  
  

  UPDATE table SET field = WHERE criteria
• The DELETE query will delete certain records within the database.

  DELETE FROM table WHERE criteria
• The INSERT INTO query is used to add additional records to an existing database.

  INSERT INTO table (fields) VALUES (data)