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 -p 2、登录之后,修改密码,并配置远程访问 登陆成功之后修改密码(密码修改为admin): ALTER USER ‘root’@‘localhost’ IDENTIFIE原创 2020-07-16 09:11:43 · 134 阅读 · 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 · 247 阅读 · 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 · 98 阅读 · 0 评论