I have a table with an archive storage mechanism , and I would like to clear it. Neither deletewill nor truncatework because of the definition of the engine. But is there any other way than deleting the whole table by recreating it?
delete
truncate
See Error # 15558 truncate does not clear the table in tables with archive storage files
Basically, the designers wanted it to work that way. Fixed a bug due to the fact that it returned an error when trying to use truncation in a table stored in the ARCHIVE storage engine.
The only workaround is to DROP and re-CREATE the table.
BLACKHOLE, .