INSERT INTO Customers (FName, LName, Email, PreferredContact) VALUES ('Zack', 'Smith', 'firstname.lastname@example.org', 'EMAIL');
This statement will insert a new row into the
Customers table. Data will only be inserted into the columns specified - note that no value was provided for the
PhoneNumber column. Note, however, that all columns marked as
not null must be included.