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.

Deleting rows from grid

BubikolRamios's profile image BubikolRamios posted 4 years ago in General Permalink
Select rows/right click/delete selected row(s)

At not so many selected rows HSQL, say 50-100+ selected rows on remote server, hangs.
It does come out of hanging after work is done.

I think instead of:
delete from table where a = 'foo' and b = 'foo1';
delete from table where a = 'foo3' and b = 'foo4';
delete from table where a = 'foo5' and b = 'foo16';
...

this might help:
delete from table
where (a = 'foo' and b = 'foo1')
or ( a = 'foo3' and b = 'foo4')
or ( a = 'foo5' and b = 'foo16')
...

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