Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. The student table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Inserting data from a query


Let's check out the first table, student.


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.