Duration: 18:33 min
Summary: In this video, we will continue our discussion of the insert statement. Previously, we created a table and then insert data into it. Today, we will use the select into approach which will create the table automatically for us. Then we will discuss the update statement and see how we can change data in the tables. After that, we will spend some time talking about the delete statement. Here I will show you couple of tricks that you can use to make sure you do not delete data unintentionally. We will comment out the delete statement so we do not run it by mistake. Then, we will see how to use the transactions to rollback or commit the data. Finally, I will explain the difference between delete and truncate. I will also explain how to drop a table.