msyql
宝藏程序员
这个作者很懒,什么都没留下…
展开
-
安装MySQL报错:The service already existsThe current server installed
报错:The service already exists!The current server installed: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" MySQL解决方法:1.以管理员身份打开命令行2.输入sc query mysql3.输入sc delete mysql如下图:原创 2022-03-09 13:20:17 · 4841 阅读 · 1 评论 -
attempted to return null from a method with a primitive return type (double)
报错:org.apache.ibatis.binding.BindingException: Mapper method 'com.shopping.dao.OrderMapper.selectYesterdaySales attempted to return null from a method with a primitive return type (double).报错代码: <select id="selectYesterdaySales" resultType="Double原创 2021-05-05 22:38:55 · 413 阅读 · 0 评论 -
安装MySQL报错:[ERROR] --initialize specified but the data directory has files in it. Aborting.
执行mysqld --initialize命令时报错:[ERROR] --initialize specified but the data directory has files in it. Aborting.报错原因是data目录中已存在文件解决方法:清空data文件内容(先执行命令net stop mysql关闭mysql service,否则可能会删除失败)...原创 2021-02-21 13:09:45 · 3591 阅读 · 0 评论 -
安装MySQL报错:[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defau
win10安装mysql5.7.23过程中在执行mysqld --initialize命令时报错:[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).解决方法:在my.ini配置文件中添加配置:[mysqld]explicit_de原创 2021-02-21 13:16:07 · 47701 阅读 · 6 评论