Mysql批量跟新多条数据的写法:
UPDATE InputFile set Date = case FileType
WHEN "basdata" THEN "2015-11-06 13:00:00"
WHEN "fluxdata" THEN "2015-11-06 13:00:00"
END
WHERE FileType IN ("basdata","fluxdata")
表结构如下:
Mysql批量跟新多条数据的写法:
UPDATE InputFile set Date = case FileType
WHEN "basdata" THEN "2015-11-06 13:00:00"
WHEN "fluxdata" THEN "2015-11-06 13:00:00"
END
WHERE FileType IN ("basdata","fluxdata")
表结构如下: