今早挺郁闷的,用navicat8 for mysql 新建了一张表。
INSERT INTO tbltradeHistory ( merchantAcctId , language , signType , payType , bankId , orderId , orderTime , orderAmount , dealId ,bankDealId , dealTime , payAmount , fee , ext1 , ext2 , payResult , errcode , signMsg , flag )
VALUES
('merchantAcctId1','language1','signType1','payType1','bankId1','orderId1','orderTime1','orderAmounta','dealId1','bankDealId1','dealTime1','payAmount1','fee1','ext11','ext12','payResult1','errcode1','signMsg1','flsag' )
这样插入的时候 一直报错。报 1136 需要插入的字段和实际插入的字段不匹配。但是数来数去,来回数了4次都发现数量是匹配的。人弄得很烦躁的。最后将这些sql语句复制到 notePad++这个编辑器查看,看是否有语法错误(因为当时觉得他 稍微看的清楚些)。 最后在notePad++上发现 INSERT INTO tbltradeHistory
(merchantAcctId,version,language,signType,payType,bankId,orderId, orderTime,orderAmount,dealId,bankDealId,dealTime,payAmount,fee,ext1,ext2,payResult,errcode,signMsg,flag )
VALUES ('merchantAcctId1'',''version1','language1','signType1','payType1'',''bankId1','orderId1'',''orderTime1','orderAmounta'',''dealId1','bankDealId1'',''dealTime1','payAmount1'',''fee1','ext11'',''ext12','payResult1'',''errcode1' , 'signMsg1' , 'flsag ' );