Inserting data into tables

Inserting data is key to populating your database tables with data. The INSERT statement allows you to insert data into tables in your database. In order to insert data, you need to gather information about your table(s).

Gathering information to insert, update, or delete data

To insert, update, or delete data, you first need to know a few things about the table:

• The name of each column: You need to know the exact name of the columns because you will be using them to specify each column in your INSERT, UPDATE, or DELETE statements. These statements are commonly referred to as data manipulation language (DML) commands.
• The order of the columns: This is especially important when you select data from...