export delete/truncate

BubikolRamios's profile image BubikolRamios posted 7 years ago in General Permalink

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.

kalvaro's profile image kalvaro posted 7 years ago Permalink

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.

Please login to leave a reply, or register at first.