NULL:
*NULL
*Inserting rows with NULL fields
Inserting rows with NULL fields
suggest changeFor example inserting an employee with no phone number and no manager into the Employees example table:
INSERT INTO Employees
(Id, FName, LName, PhoneNumber, ManagerId, DepartmentId, Salary, HireDate)
VALUES
(5, 'Jane', 'Doe', NULL, NULL, 2, 800, '2016-07-22') ;
Found a mistake? Have a question or improvement idea?
Let me know.