Mysql2docx icon indicating copy to clipboard operation
Mysql2docx copied to clipboard

Published 20 hours ago • verified publisher icon icecooly

mysql8 导出文件为空

Open yanjf90 opened this issue 5 years ago • 0 comments

MySQL5.7 导出的正常，换MySQL8.0后导出文件为空，调试发现查询所有base type类型的tables的查询条件在8.0里table_type只有大写‘BASE TYPE’才行, 字符串是大小写敏感的，搜索后发现字符集排序规则utf8_general_ci为大小写不敏感，查看库information_schema虽然是utf8_general_ci，但tables表的字符集却是空的，不知道为啥，然后在table_type 包了一层lower(table_type)后正常

yanjf90 avatar Dec 17 '19 05:12 yanjf90