mysql 删除表错误 1051解决

Simple solution that worked for me.

Try to delete the table.

drop table tableOne;
You will see error:

ERROR 1051 (42S02): Unknown table 'tableOne'
Copy the create statement of that table from another Database or write it.

CREATE TABLE tableOne ( ID int(11) NOT NULL, LOCKED tinyint(1) NOT NULL) ENGINE=InnoDB;
Successful

Query OK, 0 rows affected (0.03 sec)
Drop the table
drop table tableOne;
Successful

Query OK, 0 rows affected (0.01 sec) 
最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容