EdEarn Logo

INSERT Data

INSERT is used to add new rows to a table.

INSERT INTO users (name, age, city)
VALUES ('Alice', 25, 'Mumbai');
  • Specify columns after the table name
  • Values must match column types and order

You can insert multiple rows:

INSERT INTO users (name, age, city)
VALUES ('Bob', 30, 'Delhi'), ('Charlie', 22, 'Pune');
← PrevNext →