From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Add data to a table

Solution: Add data to a table

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial Buy for my team

Solution: Add data to a table

“

(upbeat music) - [Instructor] I hope you had fun working with the data in the Connecticut database. Let's work through the solution together. I'm going to come over to my connection sidebar and just collapse everything. So clean up my space here and then we can drill into the Connecticut database here. And I first want to take a look at the table that we built in the last challenge and specifically the different columns that we added into that table. So we have employee ID, first name, last name, department and the hire date. So these are the columns that we're going to fill in. So let's get started with that. I'll right click on the database. Choose new query and we can start our insert into command. We're going to insert into the humanresources.employees table. And actually before we get too far into this you'll notice that we have the red little squiggles underneath all of these words here. And that's because…

Contents