mysql大小写区分 lower_case_table_names与binary
来源:互联网 发布:nosql数据库入门 编辑:程序博客网 时间:2024/06/05 17:40
http://www.cnblogs.com/kingangWang/archive/2011/12/13/2285637.html
在my.cnf 中将参数 lower_case_table_names = 1 可以不区分表名的大小了。
e.g:
mysql> create table n ( a int ) ;
Query OK, 0 rows affected (0.01 sec)
mysql> create table N ( a int ) ;
ERROR 1050 (42S01): Table 'n' already exists
在my.cnf 中将参数 lower_case_table_names = 0 时:
mysql> create table n ( n int ) ;
Query OK, 0 rows affected (0.02 sec)
mysql> create table N ( n int ) ;
Query OK, 0 rows affected (0.02 sec)
另外大小写查询的问题(不受lower_case_table_names影响) :
mysql> create table a ( a varchar(50)) ;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into a values ('AAA') ,('aaa'),('AAAb'),('aaaB') ;
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select * from a ;
+------+
| a |
+------+
| AAA |
| aaa |
| AAAb |
| aaaB |
+------+
4 rows in set (0.00 sec)
mysql> select * from a where a = 'aaa' ;
+------+
| a |
+------+
| AAA |
| aaa |
+------+
2 rows in set (0.00 sec)
mysql> select * from a where a = binary 'aaa' ;
+------+
| a |
+------+
| aaa |
+------+
1 row in set (0.00 sec)
mysql> create table e ( a varchar(50) binary) ;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into e values ('AAA') ,('aaa'),('AAAb'),('aaaB') ;
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select * from e ;
+------+
| a |
+------+
| AAA |
| aaa |
| AAAb |
| aaaB |
+------+
4 rows in set (0.00 sec)
mysql> select * from e where a = 'aaa' ;
+------+
| a |
+------+
| aaa |
+------+
1 row in set (0.00 sec)
在my.cnf 中将参数 lower_case_table_names = 1 可以不区分表名的大小了。
e.g:
mysql> create table n ( a int ) ;
Query OK, 0 rows affected (0.01 sec)
mysql> create table N ( a int ) ;
ERROR 1050 (42S01): Table 'n' already exists
在my.cnf 中将参数 lower_case_table_names = 0 时:
mysql> create table n ( n int ) ;
Query OK, 0 rows affected (0.02 sec)
mysql> create table N ( n int ) ;
Query OK, 0 rows affected (0.02 sec)
另外大小写查询的问题(不受lower_case_table_names影响) :
mysql> create table a ( a varchar(50)) ;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into a values ('AAA') ,('aaa'),('AAAb'),('aaaB') ;
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select * from a ;
+------+
| a |
+------+
| AAA |
| aaa |
| AAAb |
| aaaB |
+------+
4 rows in set (0.00 sec)
mysql> select * from a where a = 'aaa' ;
+------+
| a |
+------+
| AAA |
| aaa |
+------+
2 rows in set (0.00 sec)
mysql> select * from a where a = binary 'aaa' ;
+------+
| a |
+------+
| aaa |
+------+
1 row in set (0.00 sec)
mysql> create table e ( a varchar(50) binary) ;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into e values ('AAA') ,('aaa'),('AAAb'),('aaaB') ;
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select * from e ;
+------+
| a |
+------+
| AAA |
| aaa |
| AAAb |
| aaaB |
+------+
4 rows in set (0.00 sec)
mysql> select * from e where a = 'aaa' ;
+------+
| a |
+------+
| aaa |
+------+
1 row in set (0.00 sec)
0 0
- mysql大小写区分 lower_case_table_names与binary
- mysql区分大小写配置lower_case_table_names
- Linux mysql数据库设置区分大小写lower_case_table_names
- MySQL binary 区分大小写
- lower_case_table_names=1 让MySQL不区分大小写!
- MySQL的大小写敏感性 lower_case_table_names
- MySQL的大小写敏感性 lower_case_table_names
- MySQL的大小写敏感性 lower_case_table_names
- MySQL的大小写敏感性[lower_case_table_names]
- mysql忽略大小写,lower_case_table_names配置
- (zt)MySQL的大小写敏感性 lower_case_table_names
- mysql运维-lower_case_table_names(大小写敏感)
- MySQL不区分大小写(Linux与WINDOWS)
- MySQL不区分大小写(Linux与WINDOWS)
- Mysql 不区分大小写
- mysql查询区分大小写
- mysql区分大小写
- MySQL字段区分大小写
- Spring Boot学习(一)
- 【JAVA】系统中关于自定义比例选择的功能实现
- Codeforces Gym 100623F Problem F. Fenwick Tree
- 微信小程序--Ble蓝牙
- iOS NSKeyedArchiver
- mysql大小写区分 lower_case_table_names与binary
- android_分享图片功能实现
- 汽车CAN总线关闭故障的诊断与恢复
- 学习C++的视频和书
- Freemarker模板应用
- java中Action层、Service层和Dao层的功能区分
- 应用间相互跳转(URL Schemes)
- 2016Android某公司面试题
- tensorflow入门4 windows环境下安装tf