WEEK 2: Basic SQL Commands · Lesson 13 ·

The INSERT INTO statement is used to add new data to a database. An INSERT INTO statement can contain values for some or all of its columns. If you aren’t adding values for all the columns in a table, you have to specify the columns you want values to be added to. Let’s learn about SQL’s INSERT INTO command together.


INSERT INTO states (state, drink, year, image) 
VALUES ("New Jersey", "Vodka", 2018, "vodka.jpg")