想實現 一個很簡單的功能 費了我好長時間;
目的: 把一個料號記錄COPY一份修改主鍵再存放到原表里去;
1) 憑記憶采用
Select * into a from b 的這種形式,死也不行~~
2) 上網Google了一下
==>http://fengyu.china.com/sql1.htm
INSERT (往數據表里插入記錄的語句)
INSERT INTO 表名(字段名1, 字段名2, ……) VALUES ( 值1, 值2, ……);
INSERT INTO 表名(字段名1, 字段名2, ……) SELECT (字段名1, 字段名2, ……) FROM 另外的表名;
第二個的語法很符合,決定試試.
不想還是提示: 右括號MISSING!
希奇,仔細對了一次又一次,發現語法格式和上面的一模一樣;
~~~~~~~~~~~~~~~無語
真試試看把括號去掉試試
INSERT INTO 表名(字段名1, 字段名2, ……) SELECT 字段名1, 字段名2, …… FROM 另外的表名;
OK搞定,真不懂;頭都發暈,算了,記下來,下次說不定又忘記了
INSERT INTO 表名(字段名1, 字段名2, ……) SELECT (字段名1, 字段名2, ……) FROM 另外的表名;
==>紅色的括號一定要去掉~~!!
正確貼在下面:
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,ROWVERSION
from sales_part_tab where catalog_no = '810370111F1291' and contract = 'TMP'
