Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

export delete/truncate

BubikolRamios's profile image BubikolRamios posted 2 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 2 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.