SQL, adding data to a table

How to insert data in a SQL database table

Join the 2022 Full-Stack Web Dev Bootcamp!


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

Take this table:

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

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

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

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

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

Want to become a better Web Developer? Join the 2022 Web Development Bootcamp!

⭐️⭐️⭐️ Join the 2022 Web Development Bootcamp ⭐️⭐️⭐️