1. 表名问题

    

lower_case_file_system

System Variable	Name	lower_case_file_system
	Variable Scope	Global
	Dynamic Variable	No
Permitted Values	Type	boolean

This variable describes the case sensitivity of file names on the file system where the data directory is located. OFF means file names are case sensitive, ON means they are not case sensitive. This variable is read only because it reflects a file system attribute and setting it would have no effect on the file system.

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names

 本文转自 angry_frog 51CTO博客，原文链接:http://blog.51cto.com/l0vesql/1966567