无法执行MySQL查询。 [英] Can't execute MySQL query.

问题描述

无法找出语法错误的位置。

执行查询时出错'  INSERT INTO BillPayment（StoreID，BillPaymentID，BillPaymentDate，BillNo，BillPaymentProviderID，CustomerID，CarrierID，Notes，BillAmount，IsSalesTax，SalesTaxAmount，IsPaymentTax，PaymentTaxAmount，IsExtraTax，ExtraTaxAmount ，IsFee，费用，FeeCost，折扣，DueAmount，EmployeeID，OnHold，密码，IsBonus，SendAlert，LanguageID，PrintReceipt，ShiftID，IsDeleted，IsPending，IsEnglish，RegisterID，TaxAmount）VALUES（1,8931，' 2012- 08-15 ' ，'  1914201249844  < span class =code-string>' ，（SELECT PaymentProviderID FROM BillPaymentProvider LIMIT 1），IFNULL（（SELECT CustomerID FROM Customer WHERE PhoneNumber ='（  123 ）456-7891 '  LIMIT 1），1 ），IFNULL（（SELECT CarrierID FROM Customer WHERE PhoneNumber ='（ 123 ）456-7891 '  LIMIT 1），（SELECT CarrierID FROM Carrier LIMIT 1）），'  INSERT   INTO  BillPayment（StoreID，BillPaymentID，BillPaymentDate，BillNo，BillPaymentProviderID，CustomerID，CarrierID，Notes，BillAmount，IsSalesTax，SalesTaxAmount，IsPaymentTax，PaymentTaxAmount，IsExtraTax，ExtraTaxAmount，IsFee，Fee，FeeCost，Discount ，DueAmount，EmployeeID，OnHold，Password，IsBonus，SendAlert，LanguageID，PrintReceipt，ShiftID，IsDeleted，IsPending，IsEnglish，RegisterID，TaxAmount） VALUES （ 1 ， 8932 ，'  2012-08-15'，'  1914201249844'，（ SELECT 付款mentProviderID  FROM  BillPaymentProvider LIMIT  1 ），IFNULL（（ SELECT  CustomerID  FROM 客户 WHERE  PhoneNumber = ' [phone]' LIMIT  1 ）， 1 ），IFNULL（（ SELECT  CarrierID  FROM 客户 WHERE  PhoneNumber = ' [phone]' LIMIT  1 ），（ SELECT  CarrierID  FROM 运营商限制 1 ）），' '， 20 ， 0 ， 0 。 0000 ，（ CASE   0   WHEN   0     0   else   1   END ）， 0 ，（ CASE   0   WHEN   0     0   ELSE   1   END ）， 0 ，（ CASE   0   WHEN   0  那么  0   ELSE   1  结束）， 0 ， 0 ， 0 。 0000 ， 20 ， 1 ， 0 ，' '， 0 ， 1 ， 1  ， 1 ， 1 ， 0 ，（  CASE  '  1914201249844'  WHEN  ' ' 那么  1   ELSE   0   END ）， 1 ， 1 ， 0 ）; ' ：SQL语法中有错误;检查与MySQL服务器版本对应的手册，以便在'附近使用正确的语法。 2012-08-15 ' ，'  1914201249844  ' ，（选择PaymentProviderID FROM BillPaymentProvider L''在行 1  
 
  ROLLBACK  

解决方案

您需要在列列表的右括号之后和所有出现的值声明之前添加一个空格。

Hi, Can't find out where is syntax error.

Error performing query 'INSERT INTO BillPayment (StoreID,BillPaymentID,BillPaymentDate,BillNo,BillPaymentProviderID,CustomerID,CarrierID,Notes,BillAmount,IsSalesTax,SalesTaxAmount,IsPaymentTax,PaymentTaxAmount,IsExtraTax,ExtraTaxAmount,IsFee,Fee,FeeCost,Discount,DueAmount,EmployeeID,OnHold,Password,IsBonus,SendAlert,LanguageID,PrintReceipt,ShiftID,IsDeleted,IsPending,IsEnglish,RegisterID,TaxAmount)VALUES (1,8931,'2012-08-15','1914201249844',(SELECT PaymentProviderID FROM BillPaymentProvider LIMIT 1),IFNULL((SELECT CustomerID FROM Customer WHERE PhoneNumber = '[phone]' LIMIT 1) ,1),IFNULL((SELECT CarrierID FROM Customer WHERE PhoneNumber = '[phone]' LIMIT 1) ,(SELECT CarrierID FROM Carrier LIMIT 1)),' INSERT INTO BillPayment (StoreID,BillPaymentID,BillPaymentDate,BillNo,BillPaymentProviderID,CustomerID,CarrierID,Notes,BillAmount,IsSalesTax,SalesTaxAmount,IsPaymentTax,PaymentTaxAmount,IsExtraTax,ExtraTaxAmount,IsFee,Fee,FeeCost,Discount,DueAmount,EmployeeID,OnHold,Password,IsBonus,SendAlert,LanguageID,PrintReceipt,ShiftID,IsDeleted,IsPending,IsEnglish,RegisterID,TaxAmount)VALUES (1,8932,'2012-08-15','1914201249844',(SELECT PaymentProviderID FROM BillPaymentProvider LIMIT 1),IFNULL((SELECT CustomerID FROM Customer WHERE PhoneNumber = '[phone]' LIMIT 1) ,1),IFNULL((SELECT CarrierID FROM Customer WHERE PhoneNumber = '[phone]' LIMIT 1) ,(SELECT CarrierID FROM Carrier LIMIT 1)),' ',20,0,0.0000,(CASE 0 WHEN 0 then 0 else 1 END),0,(CASE 0 WHEN 0 then 0 ELSE 1 END),0,(CASE 0 WHEN 0 THEN 0 ELSE 1 END),0,0,0.0000,20,1,0,'',0,1,1,1,1,0,(CASE '1914201249844' WHEN '' THEN 1 ELSE 0 END),1,1,0); ': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2012-08-15','1914201249844',(SELECT PaymentProviderID FROM BillPaymentProvider L' at line 1

ROLLBACK

解决方案

You need to add a space after the closing parenthesis of your column list and before the "Values" declaration at all occurrences.

这篇关于无法执行MySQL查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！