SQL, adding data to a table

How to insert data in a SQL database table

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');

Written on Mar 27, 2020

I wrote 21 books to help you become a better developer:

HTML Handbook
Next.js Pages Router Handbook
Alpine.js Handbook
HTMX Handbook
TypeScript Handbook
React Handbook
SQL Handbook
Git Cheat Sheet
Laravel Handbook
Express Handbook
Swift Handbook
Go Handbook
PHP Handbook
Python Handbook
Linux Commands Handbook
C Handbook
JavaScript Handbook
Svelte Handbook
CSS Handbook
Node.js Handbook
Vue Handbook

...download them all now!

Also, JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025