标签搜索

mysql中表名不区分大小写

冰封一夏
2021-09-28 23:21:42 / 1 阅读 / 正在检测是否收录...

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;

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

mysql> set lower_case_table_names=1;       

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

mysql>

默认是0,代表区分大小写,改为1,为不区分大小写。此参数不支持动态修改,需要在my.cnf里增加lower_case_table_names=1,然后重启MYSQL数据库即可。

mysql> show tables;

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

| Tables_in_test |

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

| car            |

| test1          |

| test2          |

| user           |

| user_201112    |

| user_201201    |

| user_201202    |

| user_201203    |

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

8 rows in set (0.00 sec)

mysql> select * from TEST2;

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

| id | tid  | name |

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

|  2 |    2 | bb   |

|  3 |    3 | cc   |

|  4 |    4 | NULL |

|  6 |    4 | ee   |

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

4 rows in set (0.04 sec)


mysql> select * from test2;

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

| id | tid  | name |

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

|  2 |    2 | bb   |

|  3 |    3 | cc   |

|  4 |    4 | NULL |

|  6 |    4 | ee   |

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

4 rows in set (0.00 sec)

 

本文转自 liang3391 51CTO博客,原文链接:http://blog.51cto.com/liang3391/842969

0

评论

博主关闭了所有页面的评论