示例代码:
mysql> show variables like '%lower_case_table_names%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 0 | +------------------------+-------+ 1 row in set (0.01 sec)
mysql> SET GLOBAL lower_case_table_names=1; Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%lower_case_table_names%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 1 | +------------------------+-------+ 1 row in set (0.00 sec)