Summary

In this lesson, you learned how to INSERT rows into a database table. You learned several ways to use INSERT, and why explicit column specification is preferred. You also learned how to use INSERT SELECT to import rows from another table, and how to use SELECT INTO to export rows to a new table. In the next lesson, you'll learn how to use UPDATE and DELETE to further manipulate table data.