修改了lower_case_table_names=1 後，業務發有個庫的表打不開了，看了表名以前是大寫，查了一下如果設定不區分大小寫，
以前的大小表名要改成小寫。重啟服務後可用！
MYSQL在LINUX下資料庫名、表名、列名、別名大小寫規則如下：
1.資料庫名與表名是嚴格區分大小寫的
2.表的別名是嚴格區分大小寫的
3.列名與列的別名在所有的情況下均是忽略大小寫的
4.變數名也是嚴格區分大小寫的
Linux環境下MySQL報Table 'xxx' doesn't exist錯誤解決方法
相關文章
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- MySQL 5.5原始碼安裝時啟動資料庫報錯"Table 'mysql.user' doesn't exist??"MySql原始碼資料庫
- MySQL查詢報錯：ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't existMySqlError
- [BUG反饋]子查詢報錯，Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- 解決安裝ubuntu系統時出現錯誤：(10, “debian-installer/locale doesn‘t exist“)Ubuntu
- 帝國CMS重新整理資料表article提示Table ‘empirecms.phome_ecms_’ doesn’t exist的解決
- about Res folder doesn't exist in android projectAndroidProject
- MYSQL報1022錯誤：Can't write;duplicate key in table '.....'MySql
- docker 容器環境下的 MySQL 拒絕連線錯誤解決辦法DockerMySql
- 解決pgpool啟動報錯 ifup[/sbin/ip] doesn't have setuid bitUI
- window環境下npm install node-sass報錯的解決方法NPM
- linux解決“XXX is not in the sudoers file”錯誤Linux
- wget下載安裝時出現錯誤doesn‘t match requested host name錯誤wget
- Check table 169P: entry XXXX does not exist的解決
- doesn't contain a valid partition tableAI
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- The file '/MasterPage.master' does not exist. 類錯誤解決方法AST
- 易優CMS【錯誤程式碼】 SQLSTATE【42S02】：Base table or view not found：1146 Table‘111.ey_admin_theme‘doesn‘t exist-eyoucmsSQLView
- dbfread報錯ValueError錯誤解決方法Error
- Linux下錯誤解決方案Linux
- Ubuntu下android開發環境配置與奇葩錯誤解決UbuntuAndroid開發環境
- Windows環境下EXP-00091錯誤的解決辦法Windows
- 解決MySql報錯：1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server的方法MySqlServer
- Windows 環境安裝 Horizon 報錯解決Windows
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- MySQL錯誤1042-Can't get hostname for your address解決方法MySql
- IBM AIX 環境啟動資料庫報 ORA-27125 錯誤解決方法IBMAI資料庫
- Linux DBCA 報ORA-12547錯誤解決方法Linux
- MySQL 中出現報錯提示： ‘Variable ‘XXX‘ is a read only variable‘的解決方法MySql
- MYSQL中 TYPE=MyISAM 錯誤的解決方法MySql
- beego報錯 table name: `xxx` not existsGo
- Linux下安裝Oracle 錯誤解決 - Error: Can't open display:127.0..0.1:0.0LinuxOracleError
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- 【linux】Can't connect to MySQL server on 'XXX' (13)問題解決方式LinuxMySqlServer