SetColumns 更新update List<> 集合 返回
this.DbClient.Updateable(dataList).WhereColumns(m=> m.Id).SetColumns( m => new Sys_User
{
CreationTime = m.CreationTime.AddDays(1)
}).ExecuteCommand();
变成sql
UPDATE `Sys_User` S INNER JOIN (
SELECT '2020-03-14 15:20:35.000' AS `CreationTime`,N'1' AS `Id`
UNION ALL
SELECT '2020-03-14 15:20:35.000' AS `CreationTime`,N'2' AS `Id`
) T ON S.`Id`=T.`Id`
SET `CreationTime` = (DATE_ADD(`CreationTime` , INTERVAL @MethodConst1 Day)) ;
报错 正确应该是
UPDATE `Sys_User` S INNER JOIN (
SELECT '2020-03-14 15:20:35.000' AS `CreationTime`,N'1' AS `Id`
UNION ALL
SELECT '2020-03-14 15:20:35.000' AS `CreationTime`,N'2' AS `Id`
) T ON S.`Id`=T.`Id`
SET S.`CreationTime` = (DATE_ADD(T.`CreationTime` , INTERVAL @MethodConst1 Day)) ;
热忱回答(1)
-
fate stay night VIP0
2020/7/5这个是什么库
0 回复