![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
风吹落叶随风飘
好看的皮囊千篇一律,有趣的灵魂万里挑一
展开
-
mysql备份脚本及遇到的坑
mysql备份脚本及遇到的坑 完整代码: @echo off set "yMd=%date:~,4%%date:~5,2%%date:~8,2%" set "hms=%time:~,2%%time:~3,2%%time:~6,2%" @echo 数据库备份 set "db1=ceshi1" set "db2=ceshi2" "C:/Program Files/MySQL/MySQL Server...原创 2019-12-23 13:34:45 · 4632 阅读 · 0 评论 -
[【MySQL】通过select语句把一列数据拼接成一条字符串]
MySQL 通过select语句把一列数据拼接成一条字符串,以逗号分隔 通过 GROUP_CONCAT SELECT GROUP_CONCAT(name) as empName FROM employee 运行结果:张三,李四,王五 sql server 通过select语句把一列数据拼接成一条字符串以逗号分隔 stuff((select ‘,’+name from employ...原创 2019-11-27 15:52:30 · 5648 阅读 · 0 评论