Oftentimes we need to insert more than one row into a table, and re-writing the insert statements many times can be tedious and inefficient. Luckily, SQL provides us with a slightly shorter syntax which basically compresses multiple `INSERT` statements into a single query.

Following is the **general syntax** for inserting multiple rows using a single insert statement:

```sql
INSERT INTO table_name (column1, column2, column3, ...)
VALUES 
    (value1_1, value1_2, value1_3, ...),
    (value2_1, value2_2, value2_3, ...),
    (value3_1, value3_2, value3_3, ...),
    ...;
```


The following example shows the syntax for inserting multiple rows into a table called `students` which has three columns `first_name`, `second_name` and `age`:


INSERT INTO students (first_name, second_name, age)
VALUES
    ('Alice', 'Smith', 20),
    ('Bob', 'Johnson', 22),
    ('Charlie', 'Brown', 19);

SELECT * FROM students;

## Tip:

This syntax has a shorter version as well, in which we don't specify the column names:

```sql
INSERT INTO table_name
VALUES 
    (value1_1, value1_2, value1_3, ...),
    (value2_1, value2_2, value2_3, ...),
    (value3_1, value3_2, value3_3, ...),
    …;
```

In this case the query will look like this:


```sql
INSERT INTO students
VALUES
    ('Alice', 'Smith', 20),
    ('Bob', 'Johnson', 22),
    ('Charlie', 'Brown', 19);

SELECT * FROM students;
```

This course offers an easy-to-follow introduction to the basics of SQL databases and the Structured Query Language (SQL). Through engaging video lessons and thoughtfully crafted exercises, you’ll explore essential concepts step by step. Each topic is explained in detail and paired with hands-on practice to ensure you not only understand but also retain what you’ve learned.


This section will introduce you to coding in SQL. It will start with some basic information related to SQL and SQL Databases in general, eventually moving towards writing basic SQL queries. The section also includes some fun exercises where you will get to practice the SQL syntax.


We will get an introduction to filtering data from our selections. This will give us control over what kind of data we fetch from the database. This section will cover the syntax for filtering data and various operators which can help us write robust conditions for conditional selection of data.

This section focuses on concepts related to sorting the tables based on the column values. Sorting can be useful in extracting the minimum or maximum values from a column or for making it easier to find relevant information quickly. We will also look at a keyword which can help us limit the number of rows that are fetched by our SELECT statements, making our queries more concise.

You will learn about useful queries and keywords that can help us in populating a database with some data. This will include queries for creating tables, and for inserting rows into those tables. We will also cover two additional keywords that can help us in making our tables more intractable and robust.

We will look at how to modify or delete data in an SQL database. This will include queries for updating or deleting rows in a table and making a copy of a table or deleting it.

Inserting Multiple Rows

Tip:

Demonstration: