INSERT, UPDATE, and DELETE

The INSERT, UPDATE, and DELETE statements are used to manipulate the values stored within a table. Each statement has its own unique operation. Let's start with INSERT-- the INSERT statement is used to add values to a table. It has the following syntax:

1INSERT INTO tableName (column1Name, column2Name, columnNName...)
2VALUES (value1, value2, valueN...)

Let's insert a new record in the following table!

1INSERT INTO Class (StudentID, StudentName, CoursesEnrolled, Attendance)
2VALUES (1, 'Olivia', 'Chemistry', '80')

The above query will generate the following output.