我已经在Windows7和Red Hat Linux上安装了MySQL。
Windows 7 MySQL版本5.6.15和Red Hat Linux MySQL版本为5.1.12
我有一个具有以下模式的表wf_params
Field Type Collation Null Key Default Extra Privileges Comment
-------------- ------------ --------------- ------ ------ ------- -------------- ------------------------------- ---------
Id bigint(20) (NULL) NO PRI (NULL) auto_increment select,insert,update,references
Name varchar(100) utf8_unicode_ci YES (NULL) select,insert,update,references
LookupId bigint(20) (NULL) YES (NULL) select,insert,update,references
ExternalAuthId bigint(20) (NULL) YES (NULL) select,insert,update,references
LastSync varchar(50) utf8_unicode_ci YES (NULL) select,insert,update,references
TaskType varchar(50) utf8_general_ci YES (NULL) select,insert,update,references 它包含数据:
Id TaskTypeId TaskType Name Type Operator Value Format IsDefault
------ ---------- -------- ----------- ------ -------- --------------- ------ -----------
1 2 Trigger labels String EqualsTo UNREAD,STARRED (NULL) 1
2 1 Trigger albumName String EqualsTo Timeline Photos (NULL) 1
3 2 Action Email String EqualsTo (NULL) (NULL) 0
4 7 Trigger MachineList String (NULL) (NULL) (NULL) 0当我执行以下查询时
SELECT UPPER( CONCAT(TaskType,'_',TaskTypeId)) 'OperationId' , NAME , VALUE
FROM wf_params WHERE IsDefault = TRUE;在Linux上,它给出了如下输出:
OperationId NAME VALUE
----------- --------- -----------------
Trigger_2 labels UNREAD,STARRED
Trigger_1 albumName Timeline Photos 但是,当我在安装了MySQL的Windows7上执行查询时,它给出了输出
OperationId NAME VALUE
----------- --------- -----------------
TRIGGER_2 labels UNREAD,STARRED
TRIGGER_1 albumName Timeline Photos 为什么会发生这种情况?为什么它不能在linux机器上转换成大写?
发布于 2015-03-18 00:02:32
检查表格是否区分大小写。特别要注意的是,在windows上,表名是不区分大小写的,而在Linux上,表名是区分大小写的。
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
https://stackoverflow.com/questions/29101408
复制相似问题