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
Read More:
- Error 1146 (42s02): table ‘database name. Table name’ doesn’t exist ‘
- mysql ERROR 1050 (42S01): Table already exists
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- 1093 – You can’t specify target table ‘table’ for update in FROM clause
- Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
- An error occurred when opensips started the service“ ERROR:core :db_ check_ table_ Version: invalid version 7 for Table dialog found “
- (element UI component table) how to add a style to a table
- Errors in IntelliJ ieeasql statements and table names in @ table
- fopen,fopen_ S, wfopen_ S and_ fsopen, _ The distinction of WFS open
- ValueError: Unknown label type: ‘unknown‘
- MySQL error: can’t create table ‘..’（ errno:150 ）Solutions
- PHP error Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0 Fatal error:
- failed call to cuInit: CUDA_ERROR_UNKNOWN: unknown error
- Error response from daemon: manifest for *** not found: manifest unknown: manifest unknown
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- Oracle quick replacement undo table space method