![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
丶柏木
这个作者很懒,什么都没留下…
展开
-
sql 执行顺序
(8) SELECT (9)DISTINCT<Select_list> (1) FROM <left_table> (3) <join_type>JOIN<right_table> (2) ON<join_condition> (4) WHERE<where_condition> (5) GROUP BY<group_by_list> (6) WITH {CUBE|ROLLUP} (7) HAVING<having..转载 2021-08-18 10:46:44 · 159 阅读 · 0 评论 -
mysql创建 学生表、课程表、分数表、教师表
DROP TABLE IF EXISTS `db_school`.`Student`; create table Student ( Sno varchar(20), Sname varchar(50), primary key (Sno) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `db_school`.`Course`; create table Course ( Cno varchar(20), Cname .转载 2021-03-17 11:43:04 · 14784 阅读 · 0 评论 -
mysql
mysql 1. 客户端连接是出现 Client does not support authentication protocol requested by server 重置密码: use mysql; alter user 'root'@'localhost' identified with mysql_native_password by '123456'; flush privileges;原创 2021-05-08 09:41:48 · 120 阅读 · 0 评论 -
pypmyadmin使用
docker启动phpmyadmin 1. 下载镜像 docker pull phpmyadmin/phpmyadmin 2. 启动 docker run -itd --name myadmin -p 8080:80 phpmyadmin 3. 登录 服务器mysql的地址和端口 用户名为mysql服务器登录的用户名 密码为mysql登录密码 4. 登录成功 ...原创 2021-05-08 09:58:07 · 394 阅读 · 0 评论