Learn SQL Database Programming

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 another table to insert into a table.
• The data type of each column: You need to know whether any of the data that you insert will fail because of a data type mismatch.
• If the column is a part of a key or constraint: You need to be aware of any NOT NULL, default, ...