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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 誤刪表 drop tableOracle
- MySQL查詢報錯:ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't existMySqlError
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及drop flashOracle
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及flashbackOracle
- drop table和truncate table的區別
- JavaScript刪除table表格中行JavaScript
- JavaScript刪除table表格列JavaScript
- 【MySQL】5.6.x InnoDB Error Table mysql.innodb_table_stats not foundMySqlError
- MySQL 5.5 報錯"ERROR 1075 (42000): Incorrect table definition"MySqlError
- oracle 11g之alter table drop unused columns checkpoint刪除表不可用列系列二Oracle
- MySQL資料災難挽救之drop tableMySql
- Table '.\mysql\proc' is marked as crashed and should be repaired 報錯MySqlAI
- JavaScript刪除table表格指定行JavaScript
- jquery table 的新增和刪除jQuery
- Backup And Recovery User's Guide-使用閃回刪除來回退DROP TABLE操作GUIIDE
- MySQL 5.6 drop database時,table metadata lock等待MySqlDatabase
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- flashback drop/query/table/database/archiveDatabaseHive
- How To Efficiently Drop A Table With Many Extents
- SNMP TABLE ERROR : Requested table is empty or does not existError
- GoldenGate "Error mapping from table.a to table.a"錯誤測試GoErrorAPP
- jQuery table表格行的新增和刪除jQuery
- oracle10g刪除Table的困惑Oracle
- MYSQL ERROR 1146 Table doesnt exist 解析MySqlError
- drop apply INSTANTIATION for one tableAPP
- audit drop table為什麼不行
- Drop table cascade constraintsAI
- [doc]How To Efficiently Drop A Table With Many Extents
- JavaScript table表格行進行刪除和新增JavaScript
- 使用JQuery刪除Table中的合併行jQuery
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- 深入解析 oracle drop table內部原理Oracle
- DROP TABLE ** CASCADE CONSTRAINTS PURGEAI
- 【MySQL】mysql optimize tableMySql
- 刪除table表格行和列程式碼例項