sql集合

UPDATE cmsnews SET img= REPLACE( img, ‘http://192.168.0.3:81/Upload/News’, ‘upload/CmsNews’);

//字段前面加
update ct_addrbzw set des=concat(“平遥”,des)

//字段后面加
update ct_addrbzw set des=concat(des,“平遥”)

//追加一句话
SELECT concat(s.created_at,’ ‘,s.category,’ ‘,s.title,’ ',s.descr) FROM 表名

//case 使用
SELECT s.id,s.sym,s.applyName,s.title,s.stts,date_format(s.finishDate, ‘%Y-%m-%d’),date_format(s.finishDate, ‘%Y-%m-%d’),
CASE item.itemType
WHEN ‘XK’ THEN ‘许可’
WHEN ‘QZ’ THEN ‘强制’
WHEN ‘ZS’ THEN ‘征收’
WHEN ‘QT’ THEN ‘其他’
END as 事项类型
FROM 表名

数据库连接授权
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;

一列数据拼成一条
select group_concat(item_titles) from 表名

//按日统计
SELECT DATE_FORMAT(a.accept_date,’%Y-%m-%d’) as time ,a.apply_name, count(uuid) as count FROM zwfw_worklist a GROUP BY time,a.apply_name