BROWARD (broward_ID, name, dob, address) /*source*/
TEMP (ID, name, address,dob) /*target*/

如果要将信息从BROWARD复制到TEMP， / p>

If you want to copy information from BROWARD to TEMP then:

INSERT INTO TEMP SELECT broward_ID,NAME,ADDRESS,DOB FROM BROWARD --check that the order of columns in select represents the order in the target table

如果只需要复制值 broward_ID 和 name ：

INSERT INTO TEMP(ID, name) SELECT broward_ID,NAME FROM BROWARD