export delete/truncate

MYSQL

data: it says: "delete + insert (truncate existing data)"

instead of TRUNCATE(which is faster) it executes DELETE.

BTW - it hangs if you click Cancel as in all such situations.

I suppose you mean that "truncate" is a confusing choice of words given that it has a specific and well defined meaning in SQL.

BTW, I recall that earlier HeidiSQL versions used to have a preview pane with SQL sample. I never understood why it was gone.