INSERT All Versions

Examples

• 1

  Inserting multiple rows

  edit move example delete share

  1

  You can insert multiple rows in the database at the same time:

  INSERT INTO person (name, age) VALUES 
    ('john doe', 25),
    ('jane doe', 20);
  

  created Jul 22 at 16:16

  
• 0

  Basic INSERT

  edit move example delete share

  0

  Let's say we have a simple table called person:

  CREATE TABLE person (
      person_id BIGINT,
      name VARCHAR(255).
      age INT,
      city VARCHAR(255)
  );
  

  The most basic insert involves inserting all values in the table:

  INSERT INTO person VALUES (1, 'john doe', 25, 'new york');
  

  If you want to insert only specific columns, you need to explicitly indicate which columns:

  INSERT INTO person (name, age) VALUES ('john doe', 25);
  

  Note that if any constraints exist on the table , such as NOT NULL, you will be required to include those columns in either case.

  created Jul 22 at 16:16

  
• 0

  Insert from select

  edit move example delete share

  0

  You can insert data in a table as the result of a select statement:

  INSERT INTO person SELECT * FROM tmp_person WHERE age < 30;
  

  Note that the projection of the select must match the columns required for the insert. In this case, the tmp_person table has the same columns as person.

  created Jul 22 at 16:16