Precautions

The lower_case_table_names parameter controls whether the MySQL database and table names are case sensitive. This parameter setting may affect the database or table configurations when the APIs in the following sections in this chapter are invoked.

For example, if you have set the table names to be case insensitive and enter a table name containing uppercase letters, the name of the created table may contain only lowercase letters because the letter cases are insensitive.

Therefore, when using the following APIs, ensure that the case of your input is the same as the actual case to avoid being affected by the case setting.