随笔分类 -  SQL学习

MySQL基础巩固
摘要：select distinct university from user_profile;-- distinct 去重 select device_id from user_profile limit 0,2 View Code select device_id from user_profile 阅读全文
posted @ 2023-05-17 23:49 Icy_yayaya 阅读(43) 评论(0) 推荐(0)
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a .....
摘要：navcat 登录本地失败 https://blog.csdn.net/fenniang16/article/details/81216602?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog- 阅读全文
posted @ 2023-01-29 21:38 Icy_yayaya 阅读(28) 评论(0) 推荐(0)
MySQL数据类型
摘要： 阅读全文
posted @ 2023-01-10 21:09 Icy_yayaya 阅读(15) 评论(0) 推荐(0)
SQL分类
摘要：DDL(Data Definition Language) ：操作数据库，表等 DML(Data Manipulation Language) 对表中数据进行增删改 DQL(Data Query Language) 对数据进行查询操作 DCL(Data Control Language) 数据库进行 阅读全文
posted @ 2023-01-08 23:01 Icy_yayaya 阅读(25) 评论(0) 推荐(0)
my.ini
摘要：[mysql] default-character-set=utf8 [mysqld] character-set-server=utf8 default-storage-engine=INNODB sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZE 阅读全文
posted @ 2023-01-08 22:50 Icy_yayaya 阅读(38) 评论(0) 推荐(0)
卸载MYSQL
摘要：//1、断开连接 net stop mysql //2、如果第一步没有实现在控制面板中也找不到mysql但是在进行操作时显示sql已经存在，亦可使用以下方式 mysqld -remove mysql 阅读全文
posted @ 2023-01-08 22:42 Icy_yayaya 阅读(32) 评论(0) 推荐(0)
登录他人mysql
摘要：//登录参数：mysql -u用户名 -p密码 -h要连接的mysql服务器的ip地址(默认127.0.0.1) -P端口号(默认3306) 阅读全文
posted @ 2023-01-08 22:37 Icy_yayaya 阅读(26) 评论(0) 推荐(0)
MySQL使用步骤
摘要：出现mysqld: Can't create directory 'D:\Environment\mysql-5.7.37 \data' (Errcode: 2 - No such file or directory)极大原因是my.ini的配置有问题 my.ini配置 [mysqld] based 阅读全文
posted @ 2022-05-21 21:36 Icy_yayaya 阅读(347) 评论(0) 推荐(0)