错误提示如下:
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't existselect AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
select AlarmType,RefreshTime from CLD_AlarmSetting where 1=1 ExecuteData Table 'cldcustdata.CLD_AlarmSetting' doesn't exist
原因:表名为大写,找不到表
解决办法:
编辑mysql配置文件:vi /etc/my.cnf
添加:lower_case_table_names=1 一句到文件中。
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
重启mysql 问题解决。