INSERT INTO Customers (FName, LName, Email, PreferredContact)
VALUES ('Zack', 'Smith', 'zack@example.com', '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.