Update, Insert, and Delete

Objectives:

• To learn different data manipulation languages
• To know the syntax of each

Note that in this video, I also talk about how you can set up different user access within a SQL database with limited security scope (for example a user account with only select access, etc).

Insert Statement

To add a new record in the database table, you would use a format such as this:

INSERT INTO table_name (column1, column2, column3, ...)
    VALUES (value1, value2, value3, ...);

A reference from w3schools about insert statement: https://www.w3schools.com/sql/sql_insert.asp

Update statement