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 · 14746 阅读 · 0 评论 -
mysql
mysql1. 客户端连接是出现 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 · 119 阅读 · 0 评论 -
pypmyadmin使用
docker启动phpmyadmin1. 下载镜像docker pull phpmyadmin/phpmyadmin2. 启动docker run -itd --name myadmin -p 8080:80 phpmyadmin3. 登录服务器mysql的地址和端口 用户名为mysql服务器登录的用户名 密码为mysql登录密码4. 登录成功...原创 2021-05-08 09:58:07 · 380 阅读 · 0 评论