SQL INSERT INTO

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

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