mysql
touteng_code
这个作者很懒,什么都没留下…
展开
-
SQL经典50题(Mysql多种解法)
1.SELECT Student.*,'01' AS SC1, SC1.score AS score1,'02' AS SC2, SC2.score AS score2 FROM (SELECT SId,score FROM SC WHERE CId='01') AS SC1 JOIN (SELECT SId,score FROM SC WHERE CId='02') AS SC2 ON SC1....原创 2019-11-26 17:30:39 · 544 阅读 · 0 评论 -
电脑更新后,mysql8.0登陆密码正确显示Access denied for user 'root'@'localhost' (using password: YES)
电脑更新后,mysql8.0登陆密码正确显示Access denied for user ‘root’@‘localhost’ (using password: YES)首先感谢原博https://blog.csdn.net/zyjtoto/article/details/100515585之前MySQL登陆得好好的,电脑系统更新后突然显示Access denied for user ‘roo...原创 2019-11-15 22:08:23 · 467 阅读 · 0 评论 -
mysql8.0.18安装教程简洁版
mysql8.0.18安装教程简洁版下载网址MySQL安装navicat安装下载网址mysql官网和navicat官网。MySQL安装基本按照流程走下来,其中要注意的点是:验证方式选第二个(还没弄懂为什么);可设置简单密码,用户名为root;安装完后,默认的bin文件安装路径为C:\Program Files\MySQL\MySQL Server 8.0\bin;关键一步: 设置环...原创 2019-11-02 15:46:48 · 517 阅读 · 0 评论