How to INSERT data from one Table into another in MySQL

If You want to insert one table selected data from another table. there are some syntax for insert data. Using an INSERT…SELECT statement, we can insert multiple rows of data into a table, with the result of a SELECT statement which can get data from one or more tables.

Use the following MYSQL query to insert data from one table to another in MySQL.

INSERT INTO insert_table_name(A, B, C)
  SELECT A, B, C
    FROM select_table_name

Here are Syntax for insert one table to another table like insert_table_name (target_table) and select_table_name (source_table)

INSERT INTO 
    employee_master (emp_name, city, state, zip_code) 
SELECT
    emp_name,
    city,
    state,
    zip_code
FROM
    employee_details
WHERE
    city IN ('Lucknow', 'Kanpur')