Suggest an editImprove this articleRefine the answer for “What happens if you don't specify all required fields in INSERT?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)If `INSERT` doesn't provide values for required fields (columns with a `NOT NULL` constraint), an error occurs: the DBMS won't allow the record to be inserted, and the table's data stays unchanged. **Key point:** to successfully add the record, you need to either provide a value or rely on a default value if one is set via `DEFAULT`; the error message usually points to exactly which field was violated.Shown above the full answer for quick recall.Answer (EN)ImageIf `INSERT` **doesn't provide values for required fields** (i.e. columns with a `NOT NULL` constraint): 1. **An error occurs**, the DBMS won't allow the record to be inserted. 2. **The record isn't added**, the table's data stays unchanged. 3. **The error message** usually points to exactly which field was violated. **Example:** ```sql CREATE TABLE Employees ( ID INT PRIMARY KEY, Name VARCHAR(50) NOT NULL, Age INT ); -- An error, because the Name field is required INSERT INTO Employees (ID, Age) VALUES (1, 30); ``` **Explanation:** - `Name` has `NOT NULL`, so the database requires a value for that field. - To successfully insert the record, you need to either provide a value, or rely on a **default value**, if one is set via `DEFAULT`. > Put simply, **required fields can't be left empty**, otherwise SQL won't let the record be inserted.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.