mysql truncate archive table

I have a table with the archive storage engine and I would like to clear it. Neither delete, nor truncate will work because of the engine definition. But is there any other way than dropping the whole table an recreating it?

Answers


See Bug #15558 truncate doesn't clear table on archive storage engine tables

Basically, the designers wanted it to work that way. The fix to that bug was to make it return an error when you try to use truncate on a table stored with the ARCHIVE storage engine.

The only workaround is to DROP and the re-CREATE the table.


Another workaround would be to change it to be a BLACKHOLE table, then change it back.


Need Your Help

Add slides to Bootstrap 3 carousel dynamically using jQuery

jquery twitter-bootstrap-3 slider carousel

I'm trying to add slides to Bootstrap carousel using jQuery but it is not acting as a slider in the browser. Instead it's showing the images in list view.

Cannot resolve symbol Theme, ThemeOverlay

android build.gradle android-theme android-appcompat

I updated my android studio to latest version - 3.0.1. Since then it complains 'Cannot resolve symbol' for Theme and ThemeOverlay in the following lines of code.