SQL Insert Into

How do you add new data to a table in SQL?

The `INSERT INTO` statement is fundamental in SQL for adding new rows of data to a table. It's a crucial part of data management, allowing you to populate your database with information. This statement specifies the table and the values to be inserted.

Description

-- SQL Server example
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50)
);
GO
INSERT INTO Customers (CustomerID, FirstName, LastName)
VALUES (1, 'John', 'Doe');
GO
INSERT INTO Customers (CustomerID, FirstName, LastName)
VALUES (2, 'Jane', 'Smith');
GO
SELECT * FROM Customers;

Common Mistakes

• Forgetting to specify the column names when inserting values (especially when not inserting into all columns).
• Incorrect data types for the values being inserted (e.g., inserting a string where an integer is expected).
• Using incorrect syntax for the `VALUES` clause.
• Trying to insert values into columns that have constraints (e.g., `NOT NULL` columns without providing a value).