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
);

Console

Code editor

Result

TableConsole