Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. The post table
Default values
How to auto-generate values in a database


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


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

  • 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.