Help Center/ Relational Database Service/ User Guide (Ankara Region)/ FAQs/ Database Parameter Modification/ How Do I Set Case Sensitivity for RDS for MySQL Table Names?
Updated on 2024-04-11 GMT+08:00
View PDF
Share

How Do I Set Case Sensitivity for RDS for MySQL Table Names?

You can set case sensitivity for table names while creating an instance, or change the value of the case sensitivity parameter after the instance is created.

To change the value of lower_case_table_names:

  • Ensure that each table name is unique and in correct case and there is no backup delay.
  • Perform the following operations for DB instances associated with read replicas:
    1. Change the value of lower_case_table_names for read replicas, for example, from 1 to 0.
    2. Manually reboot the primary DB instance.
    3. Change the value of lower_case_table_names for the primary DB instance, for example, from 1 to 0.
    4. Manually reboot the primary DB instance again.
  • If your instance runs MySQL 5.6 or 5.7, you can change the value of lower_case_table_names after the instance is created.
  • You can set case sensitivity for table names when creating an RDS for MySQL 5.6, 5.7, or 8.0 instance on the console or using APIs.

    The case sensitivity of table names for created RDS for MySQL 8.0 instances cannot be changed.

    • Set Table Name Case Sensitivity on the RDS console by referring to Buy a DB Instance.