MySQL
MySQL
I like study.
热爱技术
展开
-
各数据库数据操作SQL
【代码】各数据库数据操作SQL。原创 2023-05-16 10:21:16 · 59 阅读 · 0 评论 -
Windows下MySQL的安装
1.官网下载https://dev.mysql.com/downloads/mysql/这里下载第一个就行了,第二个是整合Debug和单元测试的下载后解压到相应的目录2.启动MySQL服务端程序cd D:\mysql-8.0.23-winx64D:mysqld这样mysql服务端就启动了3.生成初始密码新开一个窗口,切换到mysql安装目录/bin生成mysql的初始密码mysqld --initialize这时候data目录下会生成一个.err文件3.启动M原创 2021-03-31 17:39:05 · 89 阅读 · 0 评论 -
MySQL中InnoDB
MySQL中有很多存储引擎,MyISAM、InnoDB、BDB(支持事务)、MEMORY(存储在内存中)、MERGE、NDB Cluster、ARCHIEVE、CSV、BLACKHOLE、FEDERATED等。常用的主要是InnoDB和MyISAM,下面主要比较两种之间的区别。下面分别分别以InnoDB和MyISAM两种存储引擎创建两张表,并插入一些数据create table t1(a int not null primary key ,b int not null,c int not null,原创 2020-10-25 15:26:53 · 2407 阅读 · 0 评论 -
navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案
原文链接:https://blog.csdn.net/u013700358/article/details/80306560今天安装了navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:Client does not support authentication protocol requested by server; consider upgra...转载 2019-10-15 23:13:34 · 139 阅读 · 0 评论 -
mysql创建函数时出现This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration an
问题描述:mysql创建函数时出现This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creato...原创 2019-07-21 16:52:01 · 271 阅读 · 0 评论 -
mysql手动安装服务
问题描述:重装了一次系统,导致mysql服务没有了,所以需要安装mysql服务,使用mysql --install安装服务后,用net start mysql无法启动服务,出现以下问题解决方法:(1)修改my.init内容,如下[mysqld]basedir ="E:\MySQL\MySQL Server 8.0"datadir ="E:\MySQL\MySQL Server 8....原创 2019-07-11 19:10:23 · 162 阅读 · 0 评论 -
Navicat连接Mysql报错:Client does not support authentication protocol requested by server;
解决方法:打开命令行,输入mysq -u root -p 输入密码,登录成功(1)use mysql(2)alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘xxxx’;(3)flush privileges;问题解决...原创 2019-07-12 21:49:58 · 109 阅读 · 0 评论 -
mysql语句日期查询
查询某一个月发表的文章使用DATE_FORMAT函数把某个字段安装某种格式转化为字符串select count(*) from topic where DATE_FORMAT(created,'%Y-%m')=‘2019-09-03’原创 2019-05-09 20:55:29 · 301 阅读 · 0 评论 -
Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server;
问题:Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server;解决方法:打开mysql命令行输入一下命令alter user 'root'@'localhost' identified with mysql_native_password by '你的密...原创 2019-05-04 09:10:11 · 172 阅读 · 1 评论 -
mysql设置某字段不能重复
alter table novel.novelsort add unique(name);novel是数据库 novelsort是表名 name是字段名原创 2019-03-23 08:40:55 · 12012 阅读 · 0 评论