w1coding.comAll tutorials

SQL Insert

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL INSERT INTO Statement

The INSERT INTO statement is used to add new rows of data to a table.

Basic INSERT INTO Query

INSERT INTO Users (first_name, last_name, age, gender)
VALUES ('John', 'Doe', 30, 'Male');
    

This query adds a new user with the specified values for first_name, last_name, age, and gender.