![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
T0DO
这个作者很懒,什么都没留下…
展开
-
'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
查询数据库中Timestamp类型时报如上错误查询后得知datetime 类型取值的范围是:1000-01-01 00:00:00到9999-12-31 23:59:59timestamp类型取值的范围是:1970-01-01 00:00:00到2037-12-31 23:59:59原创 2016-12-07 12:38:57 · 296 阅读 · 0 评论 -
Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'keyword' at row 1
工具:mysql 、SQLyog - 64 bit原因:表字段插入不了中文,报标题错误解决办法:打开隐藏选项 设置字符集为Utf-8原创 2017-03-12 15:58:04 · 1930 阅读 · 0 评论 -
The USER specified AS a DEFINER ('lingshi'@'%') does NOT exist
赋予所有权限 然后刷新权限GRANT ALL PRIVILEGES ON *.* TO lingshi@"%" IDENTIFIED BY ".";FLUSH PRIVILEGES;转载 2017-03-14 18:43:40 · 380 阅读 · 0 评论 -
Access denied for user 'root'@'localhost'--mySQL 5.7版
mySQL 5.7版 解决密码登录失败Access denied for user 'root'@'localhost' (us 最近要使用Mysql数据库,所以在网上下载了一个mysql数据库,版本为5.7.10的。安装的过程特别的简单,就是因为过于的简单,所以连密码都已经被随机生成了,导致我们在进行登录时遇到密码登录失败的问题!我也是通过网上查询很多资料,最终将这个问题解决了,所转载 2017-03-14 18:22:12 · 814 阅读 · 0 评论 -
Mysq创建触发器
DELIMITER $$USE `sns`$$DROP TRIGGER /*!50032 IF EXISTS */ `t`$$CREATE TRIGGER `t` AFTER INSERT ON `tab2` FOR EACH ROW BEGIN INSERT INTO tab1(ip)VALUES(new.ip); E原创 2017-04-21 13:31:35 · 317 阅读 · 0 评论 -
Mysql外网访问本机数据库
GRANT ALL PRIVILEGES ON *.* TO '分配的用户名'@'%' IDENTIFIED BY '分配的密码' WITH GRANT OPTION;原创 2017-04-23 22:52:27 · 765 阅读 · 0 评论 -
this is incompatible with DISTINCT
Caused by: Java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘game.giftbag0_.create_date’ which is not in SELECT list; this is incompatible with DISTINCT转载 2017-08-19 18:57:33 · 5649 阅读 · 1 评论