Add data to a table

- [Instructor] To add data to a database table,…we can use the Insert keyword.…To add information, we need to tell the database…a few important things.…So, the Insert clause has a few components…in addition to just Insert.…We need to tell it what table to add data to,…what field or fields to add information in,…and then the values to put in those fields.…Let's add a record to our People table…and add the first name Bob.…To do that, I'll write INSERT INTO people…and then in parentheses…the name of the field that I want to use,…in this case, first name.…

Then the VALUES keyword and again, in parentheses,…the information that I want to put into that field.…I'll run the statement and the database tells me…that my query was executed successfully…and that one row was affected.…That's what I'd expect.…I'm adding one record and so that would be one row.…Let's take a look at the table with SELECT *…FROM people.…

And down here at the bottom of the results,…there's record 1001, Bob.…The first-name field has what we added…and the rest of the fields have Null in them…