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

Creating Tables in SQL

Your first table
CREATE TABLE basics
8. CREATE TABLE with multiple columns
Entity Relationship Diagrams (ERD)
DROP - how to remove a table

Instruction

Excellent! Now, if you want to put more than one column in your table, just use commas between them:

CREATE TABLE airplane (
   id int,
   max_passengers int
);

As you can see, we've added another column max_passengers (also a number-type column) to our example table.

Exercise

Let's create a more sophisticated version of the previous table. Create a table named result with three number columns: id, score and year.

Stuck? Here's a hint!

Type

CREATE TABLE result (
    id int,
    score int,
    year int
);