添加字符:
如:有表student,字段sname
- 加后缀'MM'
update student
set sname=CONCAT(sname,'MM')
- 加前缀'MM'
update student
set sname=CONCAT('MM',sname)
日期增加:
update UserP set DayTo=dateadd(day,30,DayFrom) where DayTo is null
批量减去60天:
UPDATE UserP
SET DayTo = DATEADD(day, - 60, DayTo)
WHERE (DATEDIFF(day, DayFrom, DayTo) = 150)
批量处理空数据:UPDATE XXX
SET LastTime = '2014/6/27 18:38:18'
WHERE (LastTime IS NULL)
查找重复数据:
select bus_no from XXX where bus_no in (select bus_no from XXX group by bus_no having count(1) >= 2)