I want to achieve a very simple function, I have a long time; purpose: put a material number record COPY a modified primary key and store it in the original table;
1) use memory
SELECT * INTO A from B this form, death is not ~~
2) Internet Google
==> http://fengyu.china.com/sql1.htm
INSERT (inserted a record in the data) Insert INTO table name (field name 1, field name 2, ...) VALUES (value 1, value 2, ...); Insert INTO table name (field name 1, field name 2, ...) SELECT (field name 1, field name 2, ...) from another table name;
The second grammar is very compliant, decided to try it. Don't want to be prompted: Right brackets Missing!
Strange, carefully once again, discover the grammatical format and the same exact same; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Field name 2, ...) SELECT field name 1, field name 2, ... from another table name;
Ok is getting it, I really don't understand; my head is dizzy, forget it, I'll, I will forget it next time.
INSERT INTO table name (field name 1, field name 2, ...) SELECT (field name 1, field name 2, ...) from another table name; ==> Red parentheses must go ~~ !!
Passed correctly below:
insert into sales_part_tab (CATALOG_NO, contract, PART_NO, CATALOG_GROUP, BONUS_BASIS_FLAG, BONUS_VALUE_FLAG, ENG_ATTRIBUTE, CUSTOMS_STAT_NO, NOTE_ID, DISCOUNT_GROUP, PRINT_CONTROL_CODE, NOTE_TEXT, PACKAGE_TYPE, SALES_UNIT_MEAS, PACKAGE_WEIGHT, ACTIVEIND, PRICE_CONV_FACTOR, CATALOG_DESC, PRICE_UNIT_MEAS, CATALOG_TYPE, CONV_FACTOR, COST, DATE_ENTERED, lIST_PRICE, PRICE_CHANGE_DATE, PURCHASE_FLAG, SO_FLAG, VOLUME, WEIGHT_GROSS, WEIGHT_NET, FEE_CODE, TAXABLE, PROPOSED_PARCEL_QTY, CLOSE_TOLERANCE, SALES_PRICE_GROUP_ID, CONFIGURATION, WARRANTY, CREATE_SM_OBJECT_OPTION, EAN_NO, SALES_PART_SOURCING, EXPECTED_AVERAGE_PRICE, PURCHASE_PART_NO, REPLACEMENT_PART_NO, DATE_OF_REPLACEMENT, CUST_WARRANTY_ID, NON_INV_PART_TYPE, INTRASTAT_CONV_FACTOR, rOWVERSION)
select CATALOG_NO, 'PCB', PART_NO, CATALOG_GROUP, BONUS_BASIS_FLAG, BONUS_VALUE_FLAG, ENG_ATTRIBUTE, CUSTOMS_STAT_NO, NOTE_ID, DISCOUNT_GROUP, PRINT_CONTROL_CODE, NOTE_TEXT, PACKAGE_TYPE, SALES_UNIT_MEAS, PACKAGE_WEIGHT, ACTIVEIND, PRICE_CONV_FACTOR, CATALOG_DESC, PRICE_UNIT_MEAS, CATALOG_TYPE, CONV_FACTOR, COST, DATE_ENTERED, LIST_PRICE , PRICE_CHANGE_DATE, PURCHASE_FLAG, SO_FLAG, VOLUME, WEIGHT_GROSS, WEIGHT_NET, FEE_CODE, TAXABLE, PROPOSED_PARCEL_QTY, CLOSE_TOLERANCE, SALES_PRICE_GROUP_ID, CONFIGURATION, WARRANTY, CREATE_SM_OBJECT_OPTION, EAN_NO, SALES_PART_SOURCING, EXPECTED_AVERAGE_PRICE, PURCHASE_PART_NO, REPLACEMENT_PART_NO, DATE_OF_REPLACEMENT, CUST_WARRANTY_ID, NON_INV_PART_TYPE, INTRASTAT_CONV_FACTOR, ROWVERSIONfrom sales_part_tab where Catalog_no = '810370111f1291' and contract = 'TMP'
