SQL: Easy SQL Programming & Database Management For Beginners, Your Step-By-Step Guide To Learning The SQL Database by Alvaro Felix

Author:Alvaro, Felix
Language: eng
Format: epub
Publisher: UNKNOWN
Published: 2016-11-01T16:00:00+00:00

Only Selected Columns at a Time

In Chapter 5, the JobPosition field of Customer_TBL table was defined to allow null values. If in case you have a new customer but you do not know his position yet in the company, then you can leave the JobPosition field blank while providing the necessary information for the rest of the fields.

To add a new record without providing data for the JobPosition field:

Enter the following SQL lines (make sure you indicate the column names):

INSERT INTO Customer_TBL (CustomerID, CustomerName, CompanyName, USState, ContactNo)

VALUES (5, ‘Mike Armhs’, ‘1 Driving School’, ‘NJ’, 2011234567)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.