How to insert data from one table to another

The column names do not have to be the same. As long as you list the columns to be inserted in HH and the selected columns in the select from mm table one-to-one correspondence, of course, the Data Types on both sides should be compatible.
Insert into hh (fielda, fieldb, fieldc) select fieldx, fieldy, fieldz from mm
Copy codeThe Code is as follows:
--- Update the data that does not exist in the metering point and transfer the information in the account to the metering point.
Insert into MetricPoints (MeterID, MetricPointName, [Description], inclumentid, MediumID)
(SELECT m. MeterID, m. MetricItems + m. InstallPlace as m_MetricPointName, m. MetricItems, m. Metrics mentid, m. MediumID
FROM Meters m where not exists (SELECT 1 FROM MetricPoints WHERE MetricPoints. MeterID = m. MeterID) and m. MediumID = 2)

Reputation: a, B, all tables
Copy codeThe Code is as follows:
-- Table B exists (the two tables have the same structure)
Insert into B select * from

If only some of the two tables (fields) are the same
Copy codeThe Code is as follows:
Insert into B (col1, col2, col3, col4,...) select col1, col2, col3, col4,... from a where...

Insert table a into Table B.
Copy codeThe Code is as follows:
-- Table B does not exist
Select * into B from
//
Select (Field 1, Field 2,...) into B from