![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
石牌桥网管
这个作者很懒,什么都没留下…
展开
-
centos 8/9 安装mysql
wget http://repo.mysql.com/mysql80-community-release-el8-1.noarch.rpm rpm -ivh mysql80-community-release-el8-1.noarch.rpm yum install mysql-server mkdir /data/ vi /etc/my.cnf.d/mysql-server.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysq.原创 2020-09-11 12:11:25 · 232 阅读 · 0 评论 -
MYSQL迁移data目录
mysql> show global variables like '%datadir%'; +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | datadir | /var/lib/mysql/ | +---...原创 2020-04-10 15:27:22 · 169 阅读 · 0 评论 -
数据库无限层级结构左右之值算法
数据库无限层级结构左右之值算法 select (@node.right- @node.left -1) /2 from tree; 2.在某节点(parent)下新增一节点: update tree set right= right + 2 where right>= @parent.right; update tree set left = left +...原创 2020-04-01 12:03:14 · 367 阅读 · 1 评论