Insert Values into Table in SQL

One is to insert it one row at a time, the other is to insert multiple rows at a time. Let's first look at how we may INSERT data one row at a time.

Syntax

INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)

Example

INSERT INTO Store_Information (store_name, Sales, Date)
VALUES ('Los Angeles', 900, 'Jan-10-1999')