https://blog.csdn.net/u013415591/article/details/82692242
https://blog.csdn.net/gx_1_11_real/article/details/81066336
遷移之前沒這個問題，原來遷移后沒將lower_case_table_names加上，MySQL有點矯情，嚴格區分大小寫，，，
12:08:19,494 [ERROR]-[com.alibaba.druid.filter.logging.Log4jFilter statementLogError 152]-{conn-10088, pstmt-169279} execute error. SELECT t.region_id, t.region_name, t.region_name_en, t.region_code2, t.region_code3 FROM t_region t WHERE t.is_black = 0 AND t.parent_id = ? order by t.sort_order, convert(TRIM(t.region_name_en) USING GBK) asc
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown character set: 'GBK'
vi /etc/my.cnf
增加
lower_case_table_names=1
service mysqld start
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/105093.html
標籤：MySQL
上一篇：MySQL聯合查詢問題請教
下一篇：MySQL資料庫：資料的概念