Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to INSERT, UPDATE, and DELETE Data in SQL

Introduction
3. The post table
Default values
Summary

Instruction

The other table is named post, which stores information about authors' published blog posts. Let's look at it as well.

Exercise

Select all columns from the post table. It contains the following columns:

  • id – identifies each post.
  • author_id – identifies the author of the post.
  • title – the post's title/headline.
  • text – the content of the post.
  • modified_timestamp – when the post was created or modified.