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

0

I have a database that accidentally deletes a table and when I try to recreate it, it says the table already exists, but it does not appear. When executing the command:

SELECT * FROM INFORMATION_SCHEMA.TABLES

She does not show up! How can I fix this?

    
asked by anonymous 03.01.2019 / 10:07

1 answer

1

I managed to resolve. When I created the table, I changed ENGINE=InnoDB to ENGINE=MyISAM .

    
03.01.2019 / 10:25