如何查看mysql是否区分大小写_mysql查看是否区分大小写

mysql> show variables like '%case_table%';

+------------------------+-------+

| Variable_name | Value |

+------------------------+-------+

| lower_case_table_names | 0 |

+------------------------+-------+

1 row in set (0.00 sec)

mysql> set global lower_case_table_names=1;

ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable

mysql>

其中：(0：区分；1：不区分)

如果要想不区分大小写话：

可以修改my.ini或者my.cnf

[mysqld]

lower_case_table_names=1