谁来帮我看看问题出在哪？谢谢！

kider

你的语句看了，没有问题，在我的环境下运行了，是可以的，如下图：


提示：怀疑是你磁盘没有空间了...

kider

有关系！

kider

讲的对，原理就是这样的，分不同的表类型，分别对待。

060218 16:08:56  InnoDB: Error: table `db1/tb5` already exists in InnoDB internal
InnoDB: data dictionary. Have you deleted the .frm file
InnoDB: and not used DROP TABLE? Have you used DROP DATABASE
InnoDB: for InnoDB tables in MySQL version <= 3.23.43?
InnoDB: See the Restrictions section of the InnoDB manual.

如下也是一种解决办法：
先创建一个，再来删除！
InnoDB: You can drop the orphaned table inside InnoDB by
InnoDB: creating an InnoDB table with the same name in another
InnoDB: database and copying the .frm file to the current database.
InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
InnoDB: succeed.