![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
问题解决
小白的测试日记
分享生活中的小小心得
展开
-
MySQL SQL error: #1271 - Illegal mix of collations for operation 'UNION'
MySQL SQL error: #1271 - Illegal mix of collations for operation ‘UNION’问题复现:在执行如下语句时,数据库报错:问题原因:此类问题是由于UNION Mysql的Table对应的字段Collation字符序不同导致的,如下图:可以看出,student1表的字符集编码格式为utf8_general_ci,studen...原创 2019-09-19 14:42:30 · 4303 阅读 · 0 评论 -
The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone错误
连接数据库过程报错:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration prop...原创 2019-09-23 23:35:20 · 160 阅读 · 0 评论 -
mysql error:Loading class `com.mysql.jdbc.Driver'. This is deprecated.
连接数据库报错:Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver...原创 2019-09-23 23:38:52 · 160 阅读 · 0 评论 -
mysql error:SQL语句可以执行成功,rs.next()返回false
url = jdbc:mysql://localhost:3306/mydatabase在执行查询语句时,语句中带有中文的情况下,rs.next()总是返回false解决方法:在url后面加上?useUnicode=true&characterEncoding=utf-8,即url = jdbc:mysql://localhost:3306/mydatabase?useUn...原创 2019-09-26 10:45:28 · 961 阅读 · 0 评论