Inserting Complete Rows 1

  1. INSERT INTO customer 
  2. VALUES (
  3.     602,
  4.     1,
  5.     'IVAN',
  6.     'SIDOROV',
  7.     'ivan.sidiriv@gmail.com',
  8.     591,
  9.     1,
  10.     '2018-11-07',
  11.     NULL
  12. )

Inserting Complete Rows 2

INSERT INTO customer (
    customer_id,
    store_id,
    first_name,
    last_name,
    email,
    address_id,
    active,
    create_date,
    last_update
) VALUES (
    602,
    1,
    'IVAN',
    'SIDOROV',
    'ivan.sidiriv@gmail.com',
    591,
    1,
    '2018-11-07',
    NULL
)

Inserting Complete Rows 2

INSERT INTO customer (
    first_name,
    last_name,
    email,
    address_id,
    active,
    create_date,
    last_update,
    customer_id,
    store_id
) VALUES (
    'IVAN',
    'SIDOROV',
    'ivan.sidiriv@gmail.com',
    591,
    1,
    '2018-11-07',
    NULL,
    602,
    1
)

Inserting Partial Rows

INSERT INTO customer (
    customer_id,
    store_id,
    first_name,
    last_name,
    email,
    address_id,
    active
) VALUES (
    602,
    1,
    'IVAN',
    'SIDOROV',
    'ivan.sidiriv@gmail.com',
    591,
    1
)

Inserting Retrieved Data 1

INSERT INTO customer (
    customer_id,
    store_id,
    first_name,
    last_name,
    email,
    address_id,
    active) 
SELECT
    customer_id,
    store_id,
    first_name,
    last_name,
    email,
    address_id,
    active
FROM newCustomer

Inserting Retrieved Data 2

INSERT INTO customer (
    customer_id,
    store_id,
    first_name,
    last_name,
    email,
    address_id,
    active,
    create_date,
    last_update) 
SELECT *
FROM newCustomer

Inserting Retrieved Data 3

INSERT INTO customer
SELECT *
FROM newCustomer

Create a Copy of The Table 1

--MsSQL
SELECT *
INTO newCustomer
FROM customer

Create a Copy of The Table 2

--MySQL, Oracle, PostegreSQL, and SQLite
CREATE TABLE newCustomer AS
SELECT * FROM customer