SQL implementation code that inserts data from one table into another table

--The first of these cases

1 if the field of 2 tables is consistent and you want to insert all the data, you can use this method:

INSERT into target table SELECT * from source table;

2 "For example, to insert the articles table into the Newarticles table, it is:

INSERT into Newarticles SELECT * from articles;

3 If you want to import only the specified fields, you can use this method:

INSERT into Target table (field 1, Field 2, ...) SELECT Field 1, Field 2, ... From source table;

--Here's the second case

4 If you put one table's data in another table that does not exist:
SELECT * into target non-existent table from source table

5 If you want to import only the specified fields, you can use this method:

Select field 1, Field 2, ... into target non-existent table from source table

SQL implementation code that inserts data from one table into another table