Table already exists when creating a new mysql table, even if it does not exist

Question

I have a database from which I accidentally delete a table and when I try to recreate it, it says that the table already exists, but it doesn’t appear. When executing the command:

SELECT * FROM INFORMATION_SCHEMA.TABLES

She doesn’t show up! How can I fix this?

Answer 1

I managed to fix it. When creating the table, I changed ENGINE=InnoDB for ENGINE=MyISAM.