Course

Multiple Tables - Exercise

So far we've been creating, selecting, and inserting into just one table in our Database. The table. The real power of SQL databases comes from not just making multiple tables, but connecting those tables together.

In the following lessons, we'll explore creating another table called "Posts" and connecting this table to our "Users" table so that we can each with a .

The first step will be to actually create the Posts table. It will be just like creating the Users table, but we'll want some slightly different information. We'll need these columns for our table:

  • id
  • title
  • content
  • createdAt
  • updatedAt

See if you can create this table locally in your MySQL database, or on db-fiddle.

0 Comments

"Please login to view comments"

glass-bbok

Join the Conversation!

Subscribing gives you access to the comments so you can share your ideas, ask questions, and connect with others.

Upgrade your account
tick-guideNext Lesson

Multiple Tables - Solution