Zarathusa的博客

连接docker中的mysql太慢：https://blog.youkuaiyun.com/flysnownet/article/details/112219928

docker安装mysql—5.7docker run -p 3306:3306 --name mysql -d mysql:5.7docker run -p 3306:3306 --name mysql-scis -v /home/admin/docker/mysql/conf:/etc/mysql/conf.d -v /home/admin/docker/mysql/logs:/var/log/mysql -v /home/admin/docker/mysql/data:/var/lib/mys

MySQL查询两个日期之间的所有日期SELECT a.Date AS dates FROM (SELECT curdate( ) - INTERVAL ( a.a + ( 10 * b.a ) + ( 100 * c.a ) ) DAY AS Date FROM (SELECT 0 AS a UNION ALLSELECT 1 UNION ALLSELECT 2 UNI...

MySQL查询某个子节点的顶级节点(根节点)或者所有父节点假设表t_menu为:id(varchar)parent_id(varchar)name(varchar)111nullaaa222111bbb333222ccc查询id为："333"的根节点的名字：SELECT T2.nameFROM ( SELECT ...

查询近12个月数据，无则补0select v.month,ifnull(b.count,0) count from ( SELECT DATE_FORMAT(CURDATE(), '%Y-%m') AS `month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 1 MONTH), '%Y-%m') AS `month` ...

Oracle创建用户和授权一、安装后修改管理员密码并登陆运行cmd命令行录入 sqlplus /nolog 无用户名登录 conn /as sysdba 连接到数据本地数据 alter user system identified by password; 修改System的密码为password登陆system创建用户和授权其中的路径一定...