Suggest an editImprove this articleRefine the answer for “How do you insert a record into a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Inserting a new record into a table is done with `INSERT INTO`, e.g. `INSERT INTO Employees (ID, Name, Age, DepartmentID) VALUES (1, 'Ivan', 30, 101);`. **Key point:** fields marked `NOT NULL` must be filled in, and an auto-incrementing field (e.g. ID) can be left out - the database assigns a unique value on its own.Shown above the full answer for quick recall.Answer (EN)ImageInserting a new record into a table is done with the `INSERT INTO` command. **Syntax:** ```sql INSERT INTO Table_Name (Field1, Field2, ..., FieldN) VALUES (Value1, Value2, ..., ValueN); ``` **Example:** ```sql INSERT INTO Employees (ID, Name, Age, DepartmentID) VALUES (1, 'Ivan', 30, 101); ``` **Explanation:** - `INSERT INTO Employees`, picks the table we're adding a record to. - `(ID, Name, Age, DepartmentID)`, specifies which fields we're filling in. - `VALUES (1, 'Ivan', 30, 101)`, the values for those fields. ### Notes - Fields marked **NOT NULL** must be filled in. - If a field is auto-incrementing (e.g. ID), it can be left out, the database assigns a unique value on its own. > Put simply, `INSERT INTO` is the SQL command for **adding one or several records** to a table.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.