insert批量插入出错。。

我爱学习

insert into CH_TaskManagement a(a,a.fAccessory,a.fCreatePeople,a.fCreateTime,a.fCycleType,a.fFID,a.fNo,a.fPlanEndTime,a.fPlanStartTime,a.fRealityEndTime,a.fRealityStratTime,a.fRemindTime,a.fStatus,a.fTaskContent,a.fTaskExecute,a.fTaskProgress,a.fTaskTheme,a.fTaskType,a.fTimedTaskEnd,a.fTimedTaskStart)
values
(guid(),'null','system',stringToDateTime('2018-05-08 09:21:31'),'一次性','null','1',stringToDateTime('2018-05-08 09:21:47'),stringToDateTime('2018-05-08 09:21:45'),stringToDateTime('2018-05-08 09:21:49'),stringToDateTime('2018-05-08 09:21:48'),stringToDateTime('2018-05-08 00:00:00'),'1','1','彩虹蜗牛集团','1','1','普通任务',stringToDateTime('2018-05-10 00:00:00'),stringToDateTime('2018-05-08 00:00:00')),

(guid(),'null','system',stringToDateTime('2018-05-08 09:21:31'),'一次性','null','1',stringToDateTime('2018-05-08 09:21:47'),stringToDateTime('2018-05-08 09:21:45'),stringToDateTime('2018-05-08 09:21:49'),stringToDateTime('2018-05-08 09:21:48'),stringToDateTime('2018-05-09 00:00:00'),'1','1','彩虹蜗牛集团','1','1','普通任务',stringToDateTime('2018-05-10 00:00:00'),stringToDateTime('2018-05-08 00:00:00')),(guid(),'null','system',stringToDateTime('2018-05-08 09:21:31'),'一次性','null','1',stringToDateTime('2018-05-08 09:21:47'),stringToDateTime('2018-05-08 09:21:45'),stringToDateTime('2018-05-08 09:21:49'),stringToDateTime('2018-05-08 09:21:48'),stringToDateTime('2018-05-10 00:00:00'),'1','1','彩虹蜗牛集团','1','1','普通任务',stringToDateTime('2018-05-10 00:00:00'),stringToDateTime('2018-05-08 00:00:00'));


编码: JUSTEP154115; 提示: KSQL语法错误, -08 00:00:00'))^^,(guid(),'null'中未找到需要的元素, 位置702期望是<EOF>


插入一条没事。。。多条就出问题了。。哪出问题了
还有这个报错  00:00:00'))^^,(guid(),   ^^意思是 这出问题了？

jishuang

sql语句也不能这样写吧
只有一个insert  into后面多个values值？
每一个都应该是insert into完整的语句
insert into CH_TaskManagement a(a,a.fAccessory,a.fCreatePeople,a.fCreateTime,a.fCycleType,a.fFID,a.fNo,a.fPlanEndTime,a.fPlanStartTime,a.fRealityEndTime,a.fRealityStratTime,a.fRemindTime,a.fStatus,a.fTaskContent,a.fTaskExecute,a.fTaskProgress,a.fTaskTheme,a.fTaskType,a.fTimedTaskEnd,a.fTimedTaskStart)
values
(guid(),'null','system',stringToDateTime('2018-05-08 09:21:31'),'一次性','null','1',stringToDateTime('2018-05-08 09:21:47'),stringToDateTime('2018-05-08 09:21:45'),stringToDateTime('2018-05-08 09:21:49'),stringToDateTime('2018-05-08 09:21:48'),stringToDateTime('2018-05-08 00:00:00'),'1','1','彩虹蜗牛集团','1','1','普通任务',stringToDateTime('2018-05-10 00:00:00'),stringToDateTime('2018-05-08 00:00:00')),

insert into CH_TaskManagement a(a,a.fAccessory,a.fCreatePeople,a.fCreateTime,a.fCycleType,a.fFID,a.fNo,a.fPlanEndTime,a.fPlanStartTime,a.fRealityEndTime,a.fRealityStratTime,a.fRemindTime,a.fStatus,a.fTaskContent,a.fTaskExecute,a.fTaskProgress,a.fTaskTheme,a.fTaskType,a.fTimedTaskEnd,a.fTimedTaskStart)
values
(guid(),'null','system',stringToDateTime('2018-05-08 09:21:31'),'一次性','null','1',stringToDateTime('2018-05-08 09:21:47'),stringToDateTime('2018-05-08 09:21:45'),stringToDateTime('2018-05-08 09:21:49'),stringToDateTime('2018-05-08 09:21:48'),stringToDateTime('2018-05-09 00:00:00'),'1','1','彩虹蜗牛集团','1','1','普通任务',stringToDateTime('2018-05-10 00:00:00'),stringToDateTime('2018-05-08 00:00:00'))

我爱学习

jishuang 发表于 2018-5-8 10:29
sql语句也不能这样写吧
只有一个insert  into后面多个values值？
每一个都应该是insert into完整的语句 ...

sql语句没有批量插入？？？？？不是。。是我记错了？

jishuang

标准的sql语句也没有这样的语法
http://www.w3school.com.cn/sql/sql_insert.asp