MySQL DROP TABLE刪除表報錯'ERROR 1051 (42S02): Unknown table'
刪除表時報錯
mysql> drop table
gns_history_1;
ERROR 1051 (42S02):
Unknown table 'gnsdb.gns_history_1'
解決方法:
進入資料目錄,使用rm命令刪除表的相關檔案
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2134680/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- create table,show tables,describe table,DROP TABLE,ALTER TABLE ,怎麼使用?
- JavaScript刪除table表格中行JavaScript
- MySQL資料災難挽救之drop tableMySql
- drop apply INSTANTIATION for one tableAPP
- alter table drop unused columns checkpoint
- [20181203]drop table後如何獲得表結構.txt
- mysqldump匯出報錯"mysqldump: Error 2013 ... during query when dumping tableMySqlError
- jQuery table表格行的新增和刪除jQuery
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- mysql Unknown error 1054MySqlError
- 深入解析 oracle drop table內部原理Oracle
- JavaScript table表格行進行刪除和新增JavaScript
- beego報錯 table name: `xxx` not existsGo
- MySQL:Analyze table導致'waiting for table flush'MySqlAI
- 易優CMS【錯誤程式碼】 SQLSTATE【42S02】:Base table or view not found:1146 Table‘111.ey_admin_theme‘doesn‘t exist-eyoucmsSQLView
- MySQL 5.6執行DDL報錯ERROR 1050 (42S01): Table 'sms/#sql-ib752' already existMySqlError
- Lua table(表)
- MySQL InnoDB File-Per-Table表空間MySql
- 動態建立具有刪除行按鈕的table表格
- js動態新增、刪除table中的tr、td、inputJS
- MySQL table into a golang strucMySqlGolang
- ERROR 1114 (HY000) The table '' is fullError
- [20221227]a mutating table error without a trigger!.txtError
- 6、MySQL刪除資料庫(DROP DATABASE語句)MySql資料庫Database
- SQLAlchemy Table(表)類方式 – Table類和Column類SQL
- MySQL 8.0.25 Bug 報"MY-013132 The table ...is full"MySql
- MySQL:Table_open_cache_hits/Table_open_cache_misses/Table_open_cache_overflowsMySql
- 修改MySQL資料型別報 Changing columns for table XXX 錯的問題MySql資料型別
- Smart Table Personalization 功能的一些單步除錯除錯
- 【mysql】table中新增列MySql
- mysql的ALTER TABLE命令MySql
- MySQL rename table方法大全MySql
- iptables報錯!iptables-restore unable to initialize table 'filterRESTFilter
- MySQL在刪除表時I/O錯誤原因分析MySql
- MySQL刪除資料表MySql
- [BUG反饋]子查詢報錯,Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- oracle drop table purge無備份bbed恢復(3/3)Oracle