Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Creating and Modifying Database Tables!
You have completed Creating and Modifying Database Tables!
Preview
In this video we'll learn about the ALTER table statement. We'll also take a minute to get familiar with the documentation for SQLite!
SQL for Copy/Paste
INSERT INTO CONCERTS VALUES (10, '2018-03-22', 'Vancouver', 'BC', 'BC Place', 'Canada');
Related Links
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
We've choose book another
concert in Vancouver, Canada.
0:00
But before we can add
to our concerts table,
0:01
we should really add a country column.
0:03
Let's see how we can do that by
using an ALTER TABLE statement.
0:06
In SQLite, ALTER TABLE can be used to
either rename a table or add a column.
0:10
Let's start by clicking Reset on our Query
to give us a nice, clean working space.
0:16
And let's delete the comment.
0:22
Then let's type ALTER TABLE
followed by the name of the table,
0:25
which for us is CONCERTS.
0:29
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up