随笔分类 -  MYSQL

mysql
mysql建立的一个自动更新组织树案案例
摘要：组织树实现案例 一、实现功能： 根据组织基表organizitions，更新组织树子树表orgs，子树表包括每个组织树的节点为顶点子树，以及带层级格式子树。新增，删除，修改组织树基表organizitions，同时修改组织树子树表orgs。删除organizitions时，如果该节点具有子树节点，需 阅读全文
posted @ 2019-07-22 11:30 ravel 阅读(472) 评论(0) 推荐(0)
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY 切换版本
摘要：1055 Expression 1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not funct 阅读全文
posted @ 2019-07-20 20:47 ravel 阅读(198) 评论(0) 推荐(0)
mysql安装
摘要：MYSQL下载 https://www.mysql.com/downloads/ ->mysql community ->mysql community server download ->mysql community server 5.7 Mysql安装文档2019.05.06 1、 运行G:\ 阅读全文
posted @ 2019-07-02 23:01 ravel 阅读(227) 评论(0) 推荐(0)