Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The student table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Updating the list of columns in one query
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

Let's check out the first table: student.

Exercise

Select all columns from the student table. It's a pretty small table that contains only four columns:

  • The student identifier (id).
  • The first name of the student (first_name).
  • The middle name of the student (middle_name).
  • The last name of the student (last_name).

Note: Not every student has a middle name.