INSERT INTO e_deal (joint,company_joint,year,sale,asset,earn) select '91','4806
,2005,'','','' from organization t where t.id='4806';INSERT INTO e_deal (joint,
ompany_joint,year,sale,asset,earn)select '90','4806',2006,t.sale,t.asset,t.taxp
from organization t where t.id='4806';INSERT INTO e_deal (joint,company_joint,
ear,sale,asset,earn) select '89','4806',2007,'','','' from organization t where
t.id='4806'
java.sql.BatchUpdateException: You have an error in your SQL syntax; check the
anual that corresponds to your MySQL server version for the right syntax to use
near ''' from organization t where t.id='4806'' at line 1
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1086)
,2005,'','','' from organization t where t.id='4806';INSERT INTO e_deal (joint,
ompany_joint,year,sale,asset,earn)select '90','4806',2006,t.sale,t.asset,t.taxp
from organization t where t.id='4806';INSERT INTO e_deal (joint,company_joint,
ear,sale,asset,earn) select '89','4806',2007,'','','' from organization t where
t.id='4806'
java.sql.BatchUpdateException: You have an error in your SQL syntax; check the
anual that corresponds to your MySQL server version for the right syntax to use
near ''' from organization t where t.id='4806'' at line 1
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1086)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货