# SQL, adding data to a table

> Learn how to insert data into a SQL database table using the INSERT INTO command, adding a single row or multiple rows at once with one statement.

Author: [Flavio Copes](https://flaviocopes.com/about/) | Published: 2020-03-27 | Topics: [Database](https://flaviocopes.com/tags/database/) | Canonical: https://flaviocopes.com/sql-insert-data/

Once you have a table, you can insert data into it.

Take this table:

```sql
CREATE TABLE people (
  age INT,
  name CHAR(20)
);
```

You can now start adding data into it with the `INSERT INTO` command:

```sql
INSERT INTO people VALUES (37, 'Flavio');
```

You can insert multiple items separating each one with a comma:

```sql
INSERT INTO people VALUES (37, 'Flavio'), (8, 'Roger');
```