Inserting multiple rows

- [Instructor] One of the most common DML, Data Manipulation Language, statements you'll use is INSERT. I'll review the general syntax and walk through the rules for an INSERT statement and how it's used for inserting multiples rows into a table. Outside of an OLTP application, you'll want to use bulk loading of a table with a variation of INSERT to be as efficient as possible. First, I'd like to define DML statements. Simply, they make changes to a table, they can add one or many rows, insert into a table, update them, delete them, and even merge into them, with merge being a combo of the first three. Truncate is a sort of DML statement in that it doesn't mass delete, but it's more of a DDL, Data Definition, command. Any DML statement can effect zero, one, or many rows. In this lesson, we're going to focus on INSERT and inserting multiple rows at a time outside of our OLTP systems. You can do a single row insert with a VALUES clause, that's covered in another lesson. If you want to…