The reason Why I reported this error is that the storage engine used MyISAM before, but changed to InnoDB later
But I can’t delete the table because the storage engine mode used for the table before is still MyISAM, so I can’t delete it.
1 species,
Modify the storage engine of the table:
The second,
1. Delete the file of the corresponding table. Make sure the table is useless before deleting.
2. Find the location of the corresponding library in the system, such as: /var/lib/mysql/ library name
But I can’t delete the table because the storage engine mode used for the table before is still MyISAM, so I can’t delete it.
1 species,
Modify the storage engine of the table:
The second,
1. Delete the file of the corresponding table. Make sure the table is useless before deleting.
2. Find the location of the corresponding library in the system, such as: /var/lib/mysql/ library name