Mysql 学习笔记

--  concat  locate --
update  projectinfo set approveSum = concat(approveSum,'万元') where locate('万元',approveSum)=0;

concat(approveSum,'万元') 会将后边的字符拼接在后边

locate('万元',approveSum)  // 查询，被查的  未查到会返回0

---

left（字符串，位数） 截取字符串的左几位
update projectinfo set approveyear=left(projectStartTime,4)-1 where left(projectStartTime,4) in ('2018','2016','2015','2017');

---

-- replace --
update  projectinfo set projectTime = replace(projectTime,' ','');

replace（指定列，要被替换的，拿来替换的）

---

-- 查询所有重复的信息
select projectName,projectNo,count(*)  from projectinfo group by projectName having count(*)>1;