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 SQLite from the Command Line!
You have completed SQLite from the Command Line!
Preview
In this video we'll show how to read in SQL commands from a text file. Then we'll see how to format the results of a SELECT statement to make them more readable.
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
Let's try inserting a 2003
Ford Taurus as our first row.
0:00
Let's type INSERT INTO CARS, And
0:04
for the values,
we can give an ID of one for
0:09
the first row, and we need Ford,
0:15
Taurus, and 2003.
0:20
And don't forget the semi colon.
0:24
Then we can hit Enter to run it.
0:26
And since we don't see an error message,
that means that it worked.
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