![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
Exdous rivière
这个作者很懒,什么都没留下…
展开
-
mysql---修改登陆密码
1、链接mysql:(以root账号登录)mysql -u root -p初始没有密码,直接enter注意:当配置文件中将Mysql端口号更改了,则登录时需指定端口,P为大写:(这里我设置的端口为3309,,主机ip为192.168.168.152)mysql -P 3309 -h 192.168.168.152 -u root -p2、登录之后,修改密码,并配置远程访问登陆成功之后修改密码(密码修改为admin):ALTER USER ‘root’@‘localhost’ IDENTIFIE原创 2020-07-16 09:11:43 · 113 阅读 · 0 评论 -
mysql---split form(拆表并将数据导入同步)
1 insert into good_cates(cate_name) select distinct goods.cate_name from goods;2 insert into good_cates(cate_name) select goods.cate_name from goods group by goods.cate_name;原创 2020-07-14 17:11:26 · 220 阅读 · 0 评论 -
mysql------inner/left/right join on
+----+--------+-------+--------------+| id | name | price | cate_name |+----+--------+-------+--------------+| 1 | apple | 8888 | computer || 2 | huawei | 6888 | computer || 3 | lenvo | 5888 | computer || 4 | oppo | 3888原创 2020-07-14 16:26:37 · 93 阅读 · 0 评论