MySQL数据库错误: Column count doesn't match value count at row 1 1 7

Question

以下代码中出现错误，任何人都可以帮忙

INSERT INTO `qqreports`.FY15_Short_Form_Data(Quick_Quote_ID,Cc, Quote_Net_Total,Line_Item_Total,Currency_code,Item_No_1_Product_Description,Company_Name,Country_Name,Creation_Date_US_MT,Email_Address,Email_Domain_Name,Timeframe,Contact_Stat,Individual_Frequency_Indicator,Individual_Quote_Count,Product_ID,Region,Vendor_Name,Month,Year,PL,Disty_NonDisty )  SELECT  T1.Quick_Quote_ID,  T1.Cc,  T1.Quote_Net_Total,T1.Line_Item_Total,T1.Currency_Code,T1.Item_No_1_Product_Description,T1.Company_Name,T1.Country_Name,T1.Creation_Date_US_MT,T1.Email_AddressT1.Email_Domain_Name,T1.Timeframe,T1.Contact_Stat,T1.Individual_Frequency_Indicator,T1.Individual_Quote_Count,T1.Product_ID,T1.Region, T1.Vendor_Name,Month(T1.Creation_Date_US_MT) As 'Month',Year(T1.Creation_Date_US_MT) As 'Year' ,T2.Product_Line AS PL,T1.Line_Item_Total / T3.Units_1USD AS Value_In_USD,If(Left(T1.Quick_Quote_ID, 1) = '4', 'Disty', 'NonDisty') AS Disty_NonDisty FROM ngq_master AS T1 Left join abc_master AS T2 ON T1.Product_ID = T2.Item_No Left Join Currency_master T3ON T1.Currency_Code = T3.Code where Month(T1.Creation_Date_US_MT)=11 and Year(T1.Creation_Date_US_MT)=2016 order by T1.S_No;

Answer 1

现在尝试一下，您会遇到错误，因为缺少 value_in_usd，并且 select 语句中还缺少分隔两个字段的逗号。

INSERT INTO `qqreports`.FY15_Short_Form_Data 
(Quick_Quote_ID,
Cc, 
Quote_Net_Total,
Line_Item_Total,
Currency_code,
Item_No_1_Product_Description,
Company_Name,
Country_Name,
Creation_Date_US_MT,
Email_Address,
Email_Domain_Name,
Timeframe,
Contact_Stat,
Individual_Frequency_Indicator,
Individual_Quote_Count,
Product_ID,
Region,
Vendor_Name,
Month,
Year,
PL,
Value_In_USD,
Disty_NonDisty )  
SELECT  T1.Quick_Quote_ID,  
T1.Cc,  
T1.Quote_Net_Total,
T1.Line_Item_Total,
T1.Currency_Code,
T1.Item_No_1_Product_Description,
T1.Company_Name,
T1.Country_Name,
T1.Creation_Date_US_MT,
T1.Email_Address,
T1.Email_Domain_Name,
T1.Timeframe,
T1.Contact_Stat,
T1.Individual_Frequency_Indicator,
T1.Individual_Quote_Count,
T1.Product_ID,
T1.Region, 
T1.Vendor_Name,
Month(T1.Creation_Date_US_MT) As 'Month',
Year(T1.Creation_Date_US_MT) As 'Year' ,
T2.Product_Line AS PL,
T1.Line_Item_Total / T3.Units_1USD AS Value_In_USD,
If(Left(T1.Quick_Quote_ID, 1) = '4', 'Disty', 'NonDisty') AS Disty_NonDisty 
FROM ngq_master AS T1 
Left join abc_master AS T2 ON T1.Product_ID = T2.Item_No 
Left Join Currency_master T3 ON T1.Currency_Code = T3.Code 
where Month(T1.Creation_Date_US_MT)=11 and Year(T1.Creation_Date_US_MT)=2016 
order by T1.S_No;